[pgpool-general: 9087] Re: Pgpool-II SSL on Kubernetes

[Tatsuo Ishii]

> I have got all the answers for my questions. Thank you all.

Can you share the answers if don't mind?

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> Regards,
> Md. Mobarak Hossain
> Software Engineer,
> AppsCode Inc.
> 
> On Sat, Apr 13, 2024 at 12:06 AM Md. Mobarak Hossain <mobarak at appscode.com>
> wrote:
> 
>> Hello,
>> I have some questions. Can anyone please answer? I am running Pgpool on
>> kubernetes.
>> 1. What is best practice when I do not want to maintain pool_passwd?
>> 2. Can we use SSL in both Pgpool and PostgreSQL at the same time?
>> 3. Can we use SSL from Pgpool to PostgreSQL?
>> 4. How does Pgpool authenticate itself to PostgreSQL when we use SSL from
>> client to Pgpool?
>> 5. Why is there only tls.crt and tls.key in the Pgpool kubernetes setup?
>> It seems they are the root ca.crt and ca.key? But shouldn't there be
>> ca.crt, server.crt and server.key?
>> 6. If I create client.crt and client.key using the generated tls.crt and
>> tls.key by Pgpool and use these client certificates and key to connect to
>> Pgpool via psql It says -
>> psql: error: connection to server at "localhost" (127.0.0.1), port 9999
>> failed: ERROR:  CERT authentication failed
>> DETAIL:  no valid certificate presented
>> 7. Can you give a detailed example on SSL for Pgpool in Kubernetes?
>>
>> Your valuable response will be appreciated. Thanks.
>>
>> Regards,
>> Md. Mobarak Hossain
>> Software Engineer,
>> AppsCode Inc.
>>