[pgpool-general: 4789] Pg pool setup issues

[Vaidyanathaswamy, Sai (NBCUniversal)]

HI Support,

I am trying to implement pgpool database/creation and replication with 3 different server, Master/slave and class server.

I am not able to create a database, I am getting the following errors . Your help is much appreciated.
I have changed the pg_hba.conf to the following



2016-07-18 13:49:57: pid 2974: DETAIL:  Protocol Major: 3 Minor: 0 database: template1 user: openplatform
2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 0 backend
2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 1 backend
2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
2016-07-18 13:49:57: pid 2974: DETAIL:  skipping backend slot 1 because backend_status = 3
2016-07-18 13:49:57: pid 2974: DEBUG:  creating new connection to backend
2016-07-18 13:49:57: pid 2974: DETAIL:  connecting 2 backend
2016-07-18 13:49:57: pid 2974: DEBUG:  SSL is requested but SSL support is not available
2016-07-18 13:49:57: pid 2974: DEBUG:  SSL is requested but SSL support is not available
2016-07-18 13:49:57: pid 2974: DEBUG:  pool_read: read 13 bytes from backend 0
2016-07-18 13:49:57: pid 2974: DEBUG:  pool_read: read 13 bytes from backend 2
2016-07-18 13:49:57: pid 2974: DEBUG:  reading message length
2016-07-18 13:49:57: pid 2974: DETAIL:  slot: 0 length: 12
2016-07-18 13:49:57: pid 2974: DEBUG:  reading message length
2016-07-18 13:49:57: pid 2974: DETAIL:  slot: 2 length: 12
2016-07-18 13:49:57: pid 2974: DEBUG:  authentication backend
2016-07-18 13:49:57: pid 2974: DETAIL:  auth kind:5
2016-07-18 13:49:57: pid 2974: ERROR:  failed to authenticate with backend
2016-07-18 13:49:57: pid 2974: DETAIL:  MD5 authentication is not supported in replication and master-slave modes.
2016-07-18 13:49:57: pid 2974: HINT:  check pg_hba.conf settings on backend node







# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make pgpool listen
# on a non-local interface via the listen_addresses configuration parameter.
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
#local   all             postgres              md5
local   all                  all               trust
# IPv4 local connections:
host    all              postgres            127.0.0.1/32       ident
#host    all              all               ::1/128              md5
host      all             all               100.114.116.68/32    ident
host      all             all               100.114.116.69/32    ident

# 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
#host    replication     postgres        ::1/128                 ident
host     replication     postgres       100.114.116.68/32       ident
host    replication     postgres        100.114.116.69/32        ident



Thanks !
sai
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160718/6cc9003a/attachment.html>