Re: Keywords in pg_hba.conf should be field-specific

On Fri, Oct 8, 2010 at 10:13 PM, Brendan Jurd <direvus(at)gmail(dot)com> wrote:
> One of the speedbumps I hit when setting up HS+SR was naming the user
> the slave would connect as for streaming replication.  At first I
> picked 'replication', which seemed quite natural to me (and I don't
> doubt will seem natural to others as well).
>
> When I started up the slave, I got this error:
>
> FATAL:  could not connect to the primary server: FATAL:  no
> pg_hba.conf entry for replication connection from host
> "192.168.21.10", user "replication", SSL on
>
> Bzzzt.  Wrong.  There *was* such an entry in pg_hba.conf.  I wasted a
> lot of time checking my conf files for typos before I wondered whether
> there might be something wrong with using 'replication' as a username.
>  I changed the username to 'streamrep' and it all started working
> perfectly.
>
> I understand that 'replication' is a keyword as far as the database
> name is concerned, but I was surprised to find that it was treated as
> a keyword in the username field also.

Yikes. That does seems surprising.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company