Repository service does not start after patch removal or repair installation - Fatal exception password authentication failed for user "postgres"

[Andre_Sostizzo]

The Repository service does not start after patch removal or repair installation.

The Windows Application Event logs record the following:

Log Name: Application
Source: PostgreSQL
EventID:0
Level: Error:
User: N/A
General:
...
FATAL: password authentication failed for the user "postgres"
DETAIL: Password does not match for user "postgres".
           Connection matched pg_hba.conf line 80: "host  all       all      127.0.0.1/32        md5"

The Repository > Trace > System Repository logs the following:

Fatal exception password authentication failed for user "postgres"??The provider did not return a ProviderManifestToken string.??An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file

or

ERROR SERVERNAME System.Repository.Repository.Repository.QRSMain 6 <ID> domain\user Fatal exception during startup  Waiting for database timed out after 0 seconds

Resolution

The repository configuration file (C:\Program Files\Qlik\Sense\Repository\Repository.exe.config) has been modified and is no longer passing the correct credentials.

See How to reset forgotten PostgreSQL password in Qlik Sense Enterprise on Windows for a detailed solution.

Environment:

Qlik Sense Enterprise on Windows