Postgres Pro
Downloads
Home   >   mailing lists

Thread: pghba.conf

pghba.conf

From
Ramesh T
Date:
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..

Re: pghba.conf

From
Raymond O'Donnell
Date:
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>     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