Web Development Notes

ERROR psql: error: connection to server at "localhost" (127.0.0.1), port 5433 failed: ERROR: failed to authenticate with backend using SCRAM DETAIL: valid password not found Since Pgpool-II is a PostgreSQL proxy that works between clients and PostgreSQL servers, the authentication comprises two steps: Authentication between client and Pgpool-II Authentication between Pgpool-II and PostgreSQL servers Starting with Pgpool-II 4.0, Pgpool-II supports scram-sha-256 authentication. scram-sha-256 authentication method is strongly recommended because it is the most secure password-based authentication method. Solution 1 If PostgreSQL servers require  MD5  or  SCRAM  authentication for some user’s authentication but the password for that user is not present in  pool_passwd , then enabling  allow_clear_text_frontend_auth  will allow the  Pgpool-II  to use clear-text-password authentication with user to get the password in plain text form from the user ...

  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

PostgreSQL packages for Debian and Ubuntu.  PostgreSQL is an open-source, object-relational database system with a strong reputation for feature robustness, extensibility, and compliance with technical standards. Currently,  PostgreSQL  support: Debian 9  (stretch), 10 (buster), 11 (bullseye), 12 (bookworm), and unstable (sid) Ubuntu 18.04  (bionic),  20.04  (focal),  21.10  (impish, amd64 only),  22.04  (jammy) Architectures:  amd64  (64-bit x86),  i386  (32-bit x86, being phased out),  arm64  (64-bit ARM),  ppc64el  (little-endian 64-bit POWER) PostgreSQL 10, 11, 12, 13, 14, 15 devel Server extensions such as Slony-I, various PL languages, and datatypes Applications like omnidb, pgbouncer, and  pgpool-II Import the repository key from  https://www.postgresql.org/media/keys/ACCC4CF8.asc # https://wiki.postgresql.org/wiki/Apt sudo apt-get install curl ca-certificates gnupg curl http...