On 31 March 2011 04:53, Fujii Masao <masao.fu...@gmail.com> wrote: > On Thu, Mar 31, 2011 at 3:37 AM, Uwe Bartels <uwe.bart...@gmail.com> > wrote: > > when I used the postgres login 'replication' as the account for streaming > > replication I get the following error message: > > 2011-03-28 18:06:47 CEST FATAL: could not connect to the primary server: > > FATAL: no pg_hba.conf entry for replication connection from host > > "172.16.56.122", user "replication", SSL off > > > > The corresponding pg_hba.conf entry was correct and there was no other > > matching entry before that line. > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > host replication replication 172.16.56.122/32 > md5 > > > > By changing the account name - everything worked as smoth as I am used to > > with postgres. > > This is a constraint of streaming replication, and listed as a TODO item. > http://wiki.postgresql.org/wiki/TODO#Configuration_files > > Have pg_hba.conf consider "replication" special only in the database > field > * http://archives.postgresql.org/pgsql-hackers/2010-10/msg00632.php > Thanks. And Brendan was right: <<
I suspect this is going to trip a lot of people up. We could just document it and tell people that if they want to use 'replication' as a username, they'd better quote it in pg_hba.conf. >> best regards, Uwe > > Regards, > > -- > Fujii Masao > NIPPON TELEGRAPH AND TELEPHONE CORPORATION > NTT Open Source Software Center >
