Unable to correctly restore backups after changing Postgres database password

Last Updated : Oct 25, 2021 |
Prolog information
Metadata
Keywords:

Condition

When you change the Postgres database password for a user, any backups that the user took before the password change cannot be restored correctly.

Solution

  1. Restore any old backups before changing the Postgres database password for the user.
  2. Perform a new full backup after you change the Postgres database password.