Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group