: vijay patil
Sent: Thursday, January 9, 2025 12:06 AM
To: pgpool-gene...@pgpool.net ;
pgsql-general@lists.postgresql.org
Subject: Issue with Password Authentication for Pgpool
Hello Everyone,
Need assistance on below requirements.
My requirement is to prompt for a password when connecting thr
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
Hello Everyone,
Need assistance on below requirements.
My requirement is to prompt for a password when connecting through Pgpool
(port ) and to avoid using the pool_password file. However, I’m
currently getting the error related to the lack of an entry in the
pool_passwd file.
Could you plea
10 matches
Mail list logo
