Re: 'replication' keyword on .pgpass (Streaming Replication) - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: 'replication' keyword on .pgpass (Streaming Replication)
Date
Msg-id 3f0b79eb1001070113g1bd24546v1a38dbe48375007@mail.gmail.com
Whole thread Raw
In response to Re: 'replication' keyword on .pgpass (Streaming Replication)  (Magnus Hagander <magnus@hagander.net>)
Responses Re: 'replication' keyword on .pgpass (Streaming Replication)  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Thu, Jan 7, 2010 at 5:44 PM, Magnus Hagander <magnus@hagander.net> wrote:
>> Such information are supplied in the parameter 'primary_conninfo' of
>> recovery.conf. For example;
>>
>>    primary_conninfo = 'host=192.168.1.50 port=5432 user=foo'
>
> So the password can just go there, no?

Yeah, the password can be supplied in primary_conninfo.
  primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass'

Also you can use the environment variable PGPASSWORD.
Is this enough? I was thinking that some people would
complain that only the password for replication cannot
be supplied in .pgpass.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Joshua Tolley
Date:
Subject: Hot standby documentation
Next
From: "Albe Laurenz"
Date:
Subject: Re: true serializability and predicate locking