When I issue the command it is asking for passwd which I cannot used for cronjob to run at midnight.
Execute the task as user postgres (crontab for postgres, not root) and modify pg_hba.conf to permit access in trust mode (without asking for password)
e.g : local all postgres trust
You can subtitute postgres for the user you need and the database too (if the dump is not pg_dumpall)
Please help. How I do solve this problem.
I have posted this earlier the suggestion was to use pgpass but that does not help. What other way can I achive this.
Regards,
Ganesan
-- ******************************************************** Daniel Rubio Rodríguez OASI (Organisme Autňnom Per la Societat de la Informació) c/ Assalt, 12 43003 - Tarragona Tef.: 977.244.007 - Fax: 977.224.517 e-mail: [EMAIL PROTECTED] ********************************************************
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend