Re: Should database = all in pg_hba.conf match a replication connection? - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Should database = all in pg_hba.conf match a replication connection?
Date
Msg-id o2r3f0b79eb1004201852l69b2bfb5t3df8d961600ba1da@mail.gmail.com
Whole thread Raw
In response to Re: Should database = all in pg_hba.conf match a replication connection?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Should database = all in pg_hba.conf match a replication connection?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Apr 21, 2010 at 8:49 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Apr 20, 2010, at 7:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I spent a fair amount of time just now being confused about why
>> pg_hba.conf restrictions on replication connections didn't seem to be
>> getting enforced.  After looking at the code, I realize that my entry
>> with database = "replication" was indeed getting rejected as not
>> matching, but then the hba code was falling through and matching an
>> entry with database = "all".  This is not the behavior I expected
>> after
>> looking at the docs; the docs seem to imply that SR connections must
>> match an explicit replication entry in pg_hba.conf in order to
>> succeed.
>>
>> Should we change this?  It seems to me to be a good thing on security
>> grounds if replication connections can't be made through a generic
>> pg_hba entry.
>
> +1.

+1 too.

Regards,

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


pgsql-hackers by date:

Previous
From: Takahiro Itagaki
Date:
Subject: Re: [GENERAL] trouble with to_char('L')
Next
From: Mark Kirkwood
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance