From: | Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net> |
---|---|
To: | "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com> |
Cc: | hetzel(dot)devel(at)web(dot)de, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: <no subject> |
Date: | 2003-04-18 18:56:02 |
Message-ID: | 3EA04A42.8050604@e-greek.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
<libpq-files.html#PGPASSFILE> 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(at)postgresql(dot)org
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Biagioni | 2003-04-18 19:07:34 | Re: How does PG know when a database is being accessed ? |
Previous Message | Marc Mitchell | 2003-04-18 18:48:46 | Re: Performance Expectations |