pg_dump still requires password - Mailing list pgsql-admin

I want to do auto backup for pg with cronjob. The problem is it equesting for password.

I have tried with pgpass but still it does not work. I created the pgpass as per below:

echo your_host:5432:your_user:your_db:your_pass > ~/.pgpass bash$ chmod 600 ~/.pgpass

My cronjob entry is as below:

/usr/local/pgsql/bin/pg_dump --no-owner  -d helpdesk -U ganesh > /www/htdocs/sg/backup/helpdesk.dump

When I issue the command it is asking for passwd which I cannot used for cronjob to run at midnight.  

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