ERROR: pid 29754: initializing pool password, failed to open file:"/etc/pgpool2/pool_passwd"

 

If you encountered the error:

ERROR: pid 29506: initializing pool password, failed to open file:"/etc/pgpool2/pool_passwd"

Than you have to change the owner of the file pool_passwd to postgres:

sudo chown -R postgres:postgres /etc/pgpool2/pool_passwd 

Finally you can run:

su - postgres

pg_enc -m -k ~/.pgpoolkey -f /etc/pgpool2/pgpool.conf -u vstat -p

Related article on:

https://dev.smirnov.app/2022/06/psql-error-connection-to-server-failed-to-authenticate-with-backend-using-scram-detail.html