search

pgpool / pgpool2_on_k8s

56 stars 35 forks source link

Not able to run pg_md5 commands on pgpool/pgpool docker image #14

Open lungosta opened 2 years ago

lungosta commented 2 years ago

I was able to make pgpool2 work with clear text password authentication but I would like to secure the communication, when I run pg_md5 inside the docker image I get bash: pg_md5: command not found.

I tried to look for it inside the /usr directory but it's not installed there. Any advise would be highly appreciated.

Additionally, if you can recommend the best authentication method for the following scenario:

Pod (application container -> PgPool container (sidecar)) -> PostgreSQL server

I achieved this scenario using PgBouncer userlist.txt file where you don't need to specify the password on the client's connection string.

pengbo0328 commented 2 years ago

pg_md5 command is in /opt/pgpool-II/bin/pg_md5.

I recommend that you use scram-sha-256 authentication, because it is the most secure password-based authentication method.