Repository service does not start after patch removal or repair installation - Fatal exception password authentication failed for user "postgres"
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
ERROR SERVERNAME System.Repository.Repository.Repository.QRSMain 6 <ID> domain\user Fatal exception during startup Waiting for database timed out after 0 seconds