On Fri, Oct 8, 2010 at 10:13 PM, Brendan Jurd <dire...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers