Re: 'replication' keyword on .pgpass (Streaming Replication)

On Thu, Jan 7, 2010 at 07:19, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Wed, Jan 6, 2010 at 11:11 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> I haven't read up on the rest of the patch, but where do we put the
>> rest of the information about the replication master? Like which IP
>> and port to connect to? Perhaps it could/should go there?
>
> 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?

If an untrusted user has direct read access to your PGDATA directory
(where recovery.conf goes), you've lost already...

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/