On Thu, Mar 31, 2011 at 12:07 AM, Uwe Bartels <uwe.bart...@gmail.com> wrote:
> Hi, > > 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. > The standby server must have superuser access privileges required. could you please check it,if the "replication" user having superuser privileges or not. --Raghu Ram > Best Regards, > Uwe >
