[pgpool-general: 5734] Re: LDAP authentication and host/port forwarding using pgpool

[Dinesh Bhandary]

They are all slaves, created from several primary db servers.  These slave servers do not need to communicate with each other. But I need to allow people to connect to these slave servers. Giving out let's say 50 different ip and 50 different port to users is really inconvenient, that's where pgbouncer helps. It acts as a proxy. I can not use pgbouncer since it does not support ldap with TLS or SSL.

Thanks 
Dinesh 

> On Sep 20, 2017, at 7:28 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> 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
> standby servers?
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> 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.
>> 
>> Dinesh 
>> 
>> 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 ?
>>> 
>>> Yes.
>>> 
>>>> 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.
>>>> 
>>>> Dinesh
>>>> 
>>> 
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp