Thread:
Hello, I'm using PostgreSQL on my Intranet-Server. To make postgres more secure the entry in the pg_hba.conf for local users is: 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? H. Etzel ______________________________________________________________________________ UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101
* hetzel.devel@web.de <hetzel.devel@web.de> [09.04.2003 10:31]: > Hello, > I'm using PostgreSQL on my Intranet-Server. > To make postgres more secure the entry in the pg_hba.conf for local users is: > > 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? Yes. Use ~/.pgpass file. Search docs for more info on file format and other details. And next time, please, specify subject of your message. -- Victor Yegorov
Attachment
> 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
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