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

[Dinesh Bhandary]

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