assuming you are implementing kubernetes
kubectl exec -it $(kubectl get pods -l
app.kubernetes.io/component=pgpool,app.kubernetes.io/name=postgresql-ha -o
jsonpath='{.items[0].metadata.name}') -- pg_md5 -m
--config-file="/opt/bitnami/pgpool/conf/pgpool.conf" -u "foo" "bar"
//cat out pgpool af
Thanks David.
On Thu, Jan 9, 2025 at 11:42 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wednesday, January 8, 2025, vijay patil
> wrote:
>
>> Pgpool needs to be restarted for the changes to take effect.
>>
>
> You should look for and leverage the difference between when somethi
> Thanks David,
>
> I tested the configuration by setting allow_clear_text_frontend_auth = on
> and disabling the pool_hba. I made the corresponding entry in the
> pg_hba.conf file. However, while connecting through the database port
> (5432), it prompts for the password, but when connecting throu
> If we plan to use pool_hba.conf, then we must use the pool_passwd file to
> maintain passwords for all database users. This approach requires that
> every time a new user is created, their password is added to the pool_passwd
> file.
Not really. You can use pool_hba.conf with the auth method to
On Wednesday, January 8, 2025, vijay patil wrote:
> Pgpool needs to be restarted for the changes to take effect.
>
You should look for and leverage the difference between when something must
be “restarted” and when it has provided a mechanism for “reloading”.
David J.
If we plan to use pool_hba.conf, then we must use the pool_passwd file to
maintain passwords for all database users. This approach requires that
every time a new user is created, their password is added to the pool_passwd
file. The challenge with this method is that it becomes difficult to
maintain
On Wednesday, January 8, 2025, vijay patil wrote:
> This behavior might be related to how Pgpool handles authentication.
>
Having never used pgpool I very well could be wrong but from what I can
gather what you want to do is simply not possible within the current design
of pgpool. Namely you ha
Thanks David,
I tested the configuration by setting allow_clear_text_frontend_auth = on
and disabling the pool_hba. I made the corresponding entry in the
pg_hba.conf file. However, while connecting through the database port
(5432), it prompts for the password, but when connecting through Pgpool
(p
On Wednesday, January 8, 2025, vijay patil wrote:
> Could you please advise how I can achieve password authentication without
> using the pool_password file, while ensuring that Pgpool prompts for the
> password during connection?
>
https://www.pgpool.net/docs/latest/en/html/runtime-config-conne
