FATAL: password authentication failed for user "Postgres" when connecting to Postgre with PGAdmin

Sonja_Bauernfeind — Wed, 12 Apr 2023 10:48:25 GMT

Qlik Sense and Qlik NPrinting use PosgreSQL as their repositories, which you can connect to using PGAdmin. See Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting.

If the connection fails with:

FATAL: password authentication failed for user "Postgres"

Then verify that the username is written correctly and the password is correct.

In this case, Postgres is incorrect, as username and password are case-sensitive. The default user will always be postgres, all lowercase.

article FATAL: password authentication failed for user "Postgres" when connecting to Postgre with PGAdmin in Official Support Articles

FATAL: password authentication failed for user "Postgres" when connecting to Postgre with PGAdmin

Environment