[pgpool-general: 5733] Re: LDAP authentication and host/port forwarding using pgpool
ishii at sraoss.co.jp
Thu Sep 21 11:28:25 JST 2017
How do the 50 db instances communicate each other? For example, one of
them is the streaming replication primary server and rest of 49 are
SRA OSS, Inc. Japan
> Thank you for your response.
> Re: handling multiple connection.
> I have about 50 db instances running on each separate port on several boxes. Right now we just give one port to user, which is 6432, that's the port pgbouncer listens on. Then pgbouncer routes the connection to a different port/host based on the name of the db provided. This can be mapped in pgbouncer config file. The benefits of This mapping is end user do not need to know port/host of each db. I would like to know if pgpool can do the sames.
> On Sep 20, 2017, at 5:53 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>> Hi All –
>>> I need to find out if pgpool supports the following.
>>> 1. Can pgpool support LDAP authentication for db user ?
>>> 2. Can pgpool do host/port forwarding like pgbouncer does ? For example, db1 = host=127.0.0.1 port=5433 db2 = host=127.0.0.1 port=5434
>> I am not familiar with pgbouncer but if your questions is whether
>> Pgpool-II can handle connections to multiple PostgreSQL database
>> clusters, then the answer is yes.
>>> Thanks for your help.
>> Best regards,
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
More information about the pgpool-general