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

From Magnus Hagander
Subject Re: 'replication' keyword on .pgpass (Streaming Replication)
Date
Msg-id 9837222c1001070044wa10c5b6md5b9f20848732d62@mail.gmail.com
Whole thread Raw
In response to Re: 'replication' keyword on .pgpass (Streaming Replication)  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: 'replication' keyword on .pgpass (Streaming Replication)  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
On Thu, Jan 7, 2010 at 07:19, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Wed, Jan 6, 2010 at 11:11 PM, Magnus Hagander <magnus@hagander.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 HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Takahiro Itagaki
Date:
Subject: Re: Buffer statistics for pg_stat_statements
Next
From: Magnus Hagander
Date:
Subject: Re: 'replication' keyword on .pgpass (Streaming Replication)