Re: pghba.conf

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Ramesh T <rameshparnanditech(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pghba.conf
Date: 2015-08-03 15:43:51
Message-ID: 55BF8C37.2050801@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tobias Fielitz 2015-08-04 01:55:34 Get additional constraint information
Previous Message Ramesh T 2015-08-03 09:52:08 pghba.conf