[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