pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfe_sendauth: no password supplied - PostgreSQL 9.2
4+ messages / 3 participants
[nested] [flat]
* fe_sendauth: no password supplied - PostgreSQL 9.2
@ 2016-08-07 20:10 Patrick B <patrickbakerbr@gmail.com>
2016-08-07 20:21 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 Lucas Possamai <drum.lucas@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Patrick B @ 2016-08-07 20:10 UTC (permalink / raw)
To: pgsql-admin
Hi guys,
I'm trying to connect a slave server to another slave, using cascading
replication.
slave01 = Slave server connected from master
slave02 = New slave server connected from slave01
Error on slave02:
FATAL: could not connect to the primary server: fe_sendauth: no password
> supplied
Do you guys know what can be?
pg_hba.conf on both servers:
> # TYPE DATABASE USER ADDRESS METHOD
> # "local" is for Unix domain socket connections only
> local all all peer
> # IPv4 local connections:
> host all all 0.0.0.0/0 md5
> host replication replicator 0.0.0.0/0 md5
> # IPv6 local connections:
> host all all ::1/128 md5
> host replication replicator ::1/128 md5
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> #local replication postgres peer
> #host replication postgres 127.0.0.1/32 ident
Cheers
Patrick
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: fe_sendauth: no password supplied - PostgreSQL 9.2
2016-08-07 20:10 fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
@ 2016-08-07 20:21 ` Lucas Possamai <drum.lucas@gmail.com>
2016-08-07 20:32 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Lucas Possamai @ 2016-08-07 20:21 UTC (permalink / raw)
To: Patrick B <patrickbakerbr@gmail.com>; +Cc: pgsql-admin
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 <http://0.0.0.0/0>* for the IP address of slave02
server.
Cheers;
Lucas
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: fe_sendauth: no password supplied - PostgreSQL 9.2
2016-08-07 20:10 fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
2016-08-07 20:21 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 Lucas Possamai <drum.lucas@gmail.com>
@ 2016-08-07 20:32 ` Patrick B <patrickbakerbr@gmail.com>
2016-08-25 08:33 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 jaime soler <jaime.soler@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Patrick B @ 2016-08-07 20:32 UTC (permalink / raw)
To: Lucas Possamai <drum.lucas@gmail.com>; +Cc: pgsql-admin
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 <http://0.0.0.0/0>* for the IP address of slave02
> server.
>
Hi Lucas!!
That worked... thanks a lot! :)
Patrick
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: fe_sendauth: no password supplied - PostgreSQL 9.2
2016-08-07 20:10 fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
2016-08-07 20:21 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 Lucas Possamai <drum.lucas@gmail.com>
2016-08-07 20:32 ` Re: fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
@ 2016-08-25 08:33 ` jaime soler <jaime.soler@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: jaime soler @ 2016-08-25 08:33 UTC (permalink / raw)
To: Patrick B <patrickbakerbr@gmail.com>; Lucas Possamai <drum.lucas@gmail.com>; +Cc: 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.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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-08-25 08:33 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-08-07 20:10 fe_sendauth: no password supplied - PostgreSQL 9.2 Patrick B <patrickbakerbr@gmail.com>
2016-08-07 20:21 ` Lucas Possamai <drum.lucas@gmail.com>
2016-08-07 20:32 ` Patrick B <patrickbakerbr@gmail.com>
2016-08-25 08:33 ` jaime soler <jaime.soler@gmail.com>
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