pghba.conf

Started by Ramesh Tover 10 years ago2 messagesgeneral
Jump to latest
#1Ramesh T
rameshparnanditech@gmail.com

Hi All,
I changed in pg_hba.conf like,in postgres 9.3 under linux
host replication base_backup_user 127.0.0.1/32 trust

after above changes ,restarted it .

when i try pgbasebackp getting error like,

pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry
for replication connection from host "192.168.02.64", user
"base_backup_user", SSL off

any help to resolve this issue..

In reply to: Ramesh T (#1)
Re: pghba.conf

On 03/08/2015 10:52, Ramesh T wrote:

Hi All,
I changed in pg_hba.conf like,in postgres 9.3 under linux
host replication base_backup_user 127.0.0.1/32
<http://127.0.0.1/32&gt; trust

after above changes ,restarted it .

when i try pgbasebackp getting error like,

pg_basebackup: could not connect to server: FATAL: no pg_hba.conf entry
for replication connection from host "192.168.02.64", user
"base_backup_user", SSL off

Well, the error says it all: your replication connection is coming from
192.168.02.64, whereas you specified 127.0.0.1 in pg_hba.conf.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general