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

[Dinesh Bhandary]

I will try to setup as you described. I may have more questions. Thanks so much for your help.

Dinesh 

> On Sep 20, 2017, at 8:00 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> Ok. In this case,
> 
> 1) Pgpool-II will give one port 9999 (it's configurable
>   of course) to user, which is the port Pgpool-II listens on.
> 
> 2) Those 50 PostgreSQL's ip and port can be listed in the Pgpool-II's
>   configuration file. Make sure to choose "streaming replication
>   mode" in the configuration file. When a client connects to
>   Pgpool-II, it will choose one of the servers according to the
>   "weight" parameter in the configuration file. The client connects
>   to the selected server, and Pgpool-II acts as a proxy.
> 
> 3) Usually Pgpool-II expects one of the 50 servers be the primary, but
>   you can let Pgpool-II give up searching the primary node earlier by
>   setting search_primary_node_timeout to a small number (e.g. 1) in
>   the configuration file.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> 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