[pgpool-general: 4791] Re: Pg pool setup issues
Tatsuo Ishii
ishii at postgresql.org
Tue Jul 19 09:02:25 JST 2016
[Cc: to pgpool-hackers removed since this is not related to the list]
See http://pgpool.net/mediawiki/index.php/FAQ and search "md5"
Also see the pgpool-II manual how to set up the pgpool-II authentication.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From: "Vaidyanathaswamy, Sai (NBCUniversal)" <Sai.Vaidyanathaswamy at nbcuni.com>
Subject: [pgpool-general: 4789] Pg pool setup issues
Date: Mon, 18 Jul 2016 20:59:19 +0000
Message-ID: <F2FB436BF14DEB4FAC67561BEA46313BB772C9 at USUSHEMWP013.mail.tfayd.com>
> 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
More information about the pgpool-general
mailing list