Problem Database Connection Error: 28P01 undefined:undefined after upgrade PostgreSQL #5748
dima-online
started this conversation in
Guides
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi
I installed the system as indicated on the page https://docs.requarks.io/install/ubuntu (see Setup Containers)
The documentation says to install PostgreSQL 11.
However, time goes by the database server version is very outdated.This is what the system told me.
I found an error after updating PostgreSQL to version 14:
Database Connection Error: 28P01 undefined:undefined
On the PostgreSQL server side:
FATAL: password authentication failed for user "wiki"
DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
The reason is that the new version of PostgreSQL changed the file /var/lib/postgresql/data/pg_hba.conf
the scram-sha-256 method is in this file instead of md5:
host all all all scram-sha-256
Need to return the MD5 method at least for wiki container:
Please add this clarification to the documentation
Beta Was this translation helpful? Give feedback.
All reactions