From: jaime soler <jaime.soler@gmail.com>
To: Patrick B <patrickbakerbr@gmail.com>
To: Lucas Possamai <drum.lucas@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: fe_sendauth: no password supplied - PostgreSQL 9.2
Date: Thu, 25 Aug 2016 10:33:43 +0200
Message-ID: <1472114023.9541.35.camel@gmail.com> (raw)
In-Reply-To: <CAJNY3iuch+XX=kEQGiusapvegBZgP6cwrFen7DVgO34Prb01=w@mail.gmail.com>
References: <CAJNY3iuWaaPOm-g0CVVWRYnwJsLcyBYoAbrmo2ShcNe=QnUBvQ@mail.gmail.com>
<CAE_gQfV0raZKWDaQLM+WVhJYSwYZFMSNGFU7ozs--MFj4124eQ@mail.gmail.com>
<CAJNY3iuch+XX=kEQGiusapvegBZgP6cwrFen7DVgO34Prb01=w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jaime.soler@gmail.com, patrickbakerbr@gmail.com, drum.lucas@gmail.com
Subject: Re: fe_sendauth: no password supplied - PostgreSQL 9.2
In-Reply-To: <1472114023.9541.35.camel@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox