On Wednesday, January 8, 2025, vijay patil <
vijay.postgres@gmail.com> 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 have multiple nodes so cannot rely on raw mode but raw mode is required for the kind of pass-through auth you are trying. Instead you require pool_hba.conf which itself requires the password file.
David J.