| From: | jaime soler <jaime(dot)soler(at)gmail(dot)com> |
|---|---|
| To: | Patrick B <patrickbakerbr(at)gmail(dot)com>, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: fe_sendauth: no password supplied - PostgreSQL 9.2 |
| Date: | 2016-08-25 08:33:43 |
| Message-ID: | 1472114023.9541.35.camel@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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(dot)lucas(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jaime soler | 2016-08-25 08:36:57 | Re: Does CLUSTER generate WAL data? |
| Previous Message | Poul Kristensen | 2016-08-25 07:26:06 | Re: tools to centralize postgreSQL account management |