Postgres Pro
Downloads
Home   >   mailing lists

Re: fe_sendauth: no password supplied - PostgreSQL 9.2 - Mailing list pgsql-admin

From jaime soler
Subject Re: fe_sendauth: no password supplied - PostgreSQL 9.2
Date
Msg-id 1472114023.9541.35.camel@gmail.com
Whole thread Raw
In response to Re: fe_sendauth: no password supplied - PostgreSQL 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-admin
Tree view
El lun, 08-08-2016 a las 08:32 +1200, Patrick B escribió:


2016-08-08 8:21 GMT+12:00 Lucas Possamai <drum.lucas@gmail.com>:
Change the pg_hba.conf on your slave01 server:

local   all             all                                     trust
host    all             all             0.0.0.0/0               trust
host    replication     replicator      0.0.0.0/0               trust

Replace the 0.0.0.0/0 for the IP address of slave02 server.



Hi Lucas!!

That worked... thanks a lot! :)

I think trust authentication method  is only recommended for testing I'll use md5 as you were using and you need to create a pgpass file with includes replicator password and the replication process doesn't throw any error.


Patrick

pgsql-admin by date:

Previous
From: Poul Kristensen
Date:
Subject: Re: tools to centralize postgreSQL account management
Next
From: jaime soler
Date:
Subject: Re: Does CLUSTER generate WAL data?