[pgpool-general: 4991] failed to authenticate
Mephysto
mephystoonhell at gmail.com
Wed Sep 14 00:29:18 JST 2016
Hi There,
I am getting this error:
2016-09-13 17:20:58: pid 868: ERROR: failed to authenticate
2016-09-13 17:20:58: pid 868: DETAIL: invalid authentication message
response type, Expecting 'R' and received 'E'
2016-09-13 17:20:58: pid 868: LOCATION: child.c:1362
Pgpool-II 3.5.3
postgres 9.5.3
This is my pool_hba:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all postgres md5
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host all all 0.0.0.0/0 md5
And this is my pg_hba:
# TYPE DATABASE USER ADDRESS METHOD
#local all aptredevo md5
#host all aptredevo 127.0.0.1/32 md5
local replication repmgr trust
host replication repmgr 0.0.0.0/0 trust
host redevolution redevolution 10.0.0.0/24 trust
# "local" is for Unix domain socket connections only
local all postgres trust
local repmgr repmgr trust
# IPv4 local connections:
host all postgres 127.0.0.1/32 trust
# IPv6 local connections:
host all postgres ::1/128 trust
host repmgr repmgr 0.0.0.0/0 trust
host repmgr repmgr ::1/128 trust
host all postgres 10.0.0.200/32 md5
host all postgres 91.121.182.110/32 md5
host all postgres 91.121.117.6/32 md5
host all postgres 0.0.0.0/0 reject
local redevolution redevolution_db_link md5
host redevolution redevolution_db_link 127.0.0.1/32 md5
host redevolution redevolution_db_link ::1/128 md5
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres trust
#host replication postgres 127.0.0.1/32 trust
#host replication postgres ::1/128 trust
host all all 0.0.0.0/0 md5
Can you help me please?
Thanks in advance.
Meph
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20160913/af23da10/attachment.htm>
More information about the pgpool-general
mailing list