From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Brendan Jurd <direvus(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Keywords in pg_hba.conf should be field-specific |
Date: | 2010-10-09 03:08:05 |
Message-ID: | AANLkTinrkTNkiCcdb0u8Nuzj12oiXNeqW8_=apRupvtf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-10-09 03:12:42 | Re: getting set up on git (finally) |
Previous Message | David E. Wheeler | 2010-10-09 02:23:15 | Re: GIN vs. Partial Indexes |