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

[Md. Mobarak Hossain]

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

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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240416/93a91308/attachment.htm>