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