vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.69k stars 410 forks source link

PgBouncer: Fix "local" pg_hba rule #508

Closed vitabaks closed 11 months ago

vitabaks commented 11 months ago

When switching to Unix socket for PgBouncer connections, they missed updating the pg_hba rules for "local", which is why new database users could not connect.

Issue: https://github.com/vitabaks/postgresql_cluster/issues/507

Fixed:

psql -U test -h 192.168.100.78 -p 5000 -d test
Password for user test:
psql: error: connection to server at "192.168.100.78", port 5000 failed: FATAL:  Peer authentication failed for user "test"