Re: <no subject>

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
>
>
>
>

In response to

Browse pgsql-admin by date

  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