lib / pq

Pure Go Postgres driver for database/sql
https://pkg.go.dev/github.com/lib/pq
MIT License
8.98k stars 909 forks source link

pq: unknown authentication response: 892220718 #1007

Open Al2Klimov opened 3 years ago

Al2Klimov commented 3 years ago

How to reproduce:

  1. On a fresh CentOS 7 ...
  2. Install centos-release-scl
  3. Install rh-postgresql95-postgresql
  4. Run /opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup --initdb
  5. Allow md5 authn in /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_hba.conf
  6. Run systemctl start rh-postgresql95-postgresql.service
  7. Inside su -lc psql postgres ...
  8. Create a new user and a database owned by it
  9. Try to connect to postgres://USER:PW@127.0.0.1:5432/DB?sslmode=disable&binary_parameters=yes via this lib