<p dir="ltr"></p>
<p dir="ltr">On Jul 22, 2016 11:02 PM, "Dennis Gearon" <<a href="mailto:gearond@gmail.com">gearond@gmail.com</a>> wrote:<br>
><br>
> My limited networking skills says to me that all those 127.x.x.x/32 addresses should be 127.x.x.x/24 if I am not mistaken.<br>
><br>
><br>
> On Jul 18, 2016 5:02 PM, "Tatsuo Ishii" <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br>
>><br>
>> [Cc: to pgpool-hackers removed since this is not related to the list]<br>
>><br>
>> See <a href="http://pgpool.net/mediawiki/index.php/FAQ">http://pgpool.net/mediawiki/index.php/FAQ</a> and search "md5"<br>
>> Also see the pgpool-II manual how to set up the pgpool-II authentication.<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese:<a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><br>
>><br>
>> From: "Vaidyanathaswamy, Sai (NBCUniversal)" <<a href="mailto:Sai.Vaidyanathaswamy@nbcuni.com">Sai.Vaidyanathaswamy@nbcuni.com</a>><br>
>> Subject: [pgpool-general: 4789] Pg pool setup issues<br>
>> Date: Mon, 18 Jul 2016 20:59:19 +0000<br>
>> Message-ID: <<a href="mailto:F2FB436BF14DEB4FAC67561BEA46313BB772C9@USUSHEMWP013.mail.tfayd.com">F2FB436BF14DEB4FAC67561BEA46313BB772C9@USUSHEMWP013.mail.tfayd.com</a>><br>
>><br>
>> > HI Support,<br>
>> ><br>
>> > I am trying to implement pgpool database/creation and replication with 3 different server, Master/slave and class server.<br>
>> ><br>
>> > I am not able to create a database, I am getting the following errors . Your help is much appreciated.<br>
>> > I have changed the pg_hba.conf to the following<br>
>> ><br>
>> ><br>
>> ><br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: Protocol Major: 3 Minor: 0 database: template1 user: openplatform<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: creating new connection to backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: connecting 0 backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: creating new connection to backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: connecting 1 backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: creating new connection to backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: skipping backend slot 1 because backend_status = 3<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: creating new connection to backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: connecting 2 backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: SSL is requested but SSL support is not available<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: SSL is requested but SSL support is not available<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: pool_read: read 13 bytes from backend 0<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: pool_read: read 13 bytes from backend 2<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: reading message length<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: slot: 0 length: 12<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: reading message length<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: slot: 2 length: 12<br>
>> > 2016-07-18 13:49:57: pid 2974: DEBUG: authentication backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: auth kind:5<br>
>> > 2016-07-18 13:49:57: pid 2974: ERROR: failed to authenticate with backend<br>
>> > 2016-07-18 13:49:57: pid 2974: DETAIL: MD5 authentication is not supported in replication and master-slave modes.<br>
>> > 2016-07-18 13:49:57: pid 2974: HINT: check pg_hba.conf settings on backend node<br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>> > # If you want to allow non-local connections, you need to add more<br>
>> > # "host" records. In that case you will also need to make pgpool listen<br>
>> > # on a non-local interface via the listen_addresses configuration parameter.<br>
>> > # TYPE DATABASE USER CIDR-ADDRESS METHOD<br>
>> > # "local" is for Unix domain socket connections only<br>
>> > #local all postgres md5<br>
>> > local all all trust<br>
>> > # IPv4 local connections:<br>
>> > host all postgres <a href="http://127.0.0.1/32">127.0.0.1/32</a> ident<br>
>> > #host all all ::1/128 md5<br>
>> > host all all <a href="http://100.114.116.68/32">100.114.116.68/32</a> ident<br>
>> > host all all <a href="http://100.114.116.69/32">100.114.116.69/32</a> ident<br>
>> ><br>
>> > # Allow replication connections from localhost, by a user with the<br>
>> > # replication privilege.<br>
>> > #local replication postgres peer<br>
>> > host replication postgres <a href="http://127.0.0.1/32">127.0.0.1/32</a> ident<br>
>> > #host replication postgres ::1/128 ident<br>
>> > host replication postgres <a href="http://100.114.116.68/32">100.114.116.68/32</a> ident<br>
>> > host replication postgres <a href="http://100.114.116.69/32">100.114.116.69/32</a> ident<br>
>> ><br>
>> ><br>
>> ><br>
>> > Thanks !<br>
>> > sai<br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a></p>
<p dir="ltr">Sorry about too posting, it's the default for all the web basd mail clients, and I seldom add to the great conversations here (and elsewhere) so I forgot.<br></p>