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