problem with an account name 'replication' for streaming replication

From: Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem with an account name 'replication' for streaming replication
Date: 2011-03-30 18:37:48
Message-ID: AANLkTim5d4tePba7JSvjcAEQarKuDs4PD6zvxkyMD=R5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Best Regards,
Uwe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2011-03-30 20:43:31 Re: problem with an account name 'replication' for streaming replication
Previous Message Bob Lunney 2011-03-30 18:06:21 Re: grant select script