| 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: | Whole Thread | Raw Message | 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 |