Postgres Pro
Downloads
Home   >   mailing lists

Thread: fe_sendauth: no password supplied - PostgreSQL 9.2

fe_sendauth: no password supplied - PostgreSQL 9.2

From
Patrick B
Date:
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 

Re: fe_sendauth: no password supplied - PostgreSQL 9.2

From
Lucas Possamai
Date:
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.


Cheers;
Lucas

Re: fe_sendauth: no password supplied - PostgreSQL 9.2

From
Patrick B
Date:


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! :)


Patrick

tools to centralize postgreSQL account management

From
koffi BADOH
Date:

Hi all,

Someone knows a  free centralized account management tool for PostgreSQL as  openldap ?

I have multiple  postgreSQL instance  to manage.  And I have to find an easy  account management  solution.

Pg Admin III  is not the right tool  .


thankskoff

Re: tools to centralize postgreSQL account management

From
Poul Kristensen
Date:
How about webmin?


/Poul

2016-08-24 18:55 GMT+02:00 koffi BADOH <koff10@hotmail.com>:

Hi all,

Someone knows a  free centralized account management tool for PostgreSQL as  openldap ?

I have multiple  postgreSQL instance  to manage.  And I have to find an easy  account management  solution.

Pg Admin III  is not the right tool  .


thankskoff




--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

Re: fe_sendauth: no password supplied - PostgreSQL 9.2

From
jaime soler
Date:
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