Re:

From PostgreSQL 7.3.1 Documentation, section 1.10. Environment Variables:

PGPASSWORD sets the password used if the backend demands password authentication. This functionality is deprecated for security reasons; consider migrating to use the $HOME/.pgpass file. See Victor Yegorov's response (he also recommends .pgpass) and section 1.11. Files for details.

       Andrew

A.Bhuvaneswaran wrote:

local all md5

If I want to make a dump with pg_dump, I have to insert the password. 
But I can't make a Cron-Job because I always have to insert the password!!
Is there any way to do this automatic?   

PGPASSWORD environment variable can be used.

regards,
bhuvaneswaran


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org