Backup
Profile contents, user and profile assignment status, and password history can be backed up with physical backups and the pg_dumpall command.
When dumping with SQL statements using the pg_dumpall command, database role information is backed up at the same time it is dumped.
Information
When the pg_dumpall command is run without the --no-role-passwords option, the database user's password is included in the backup file in the form of a encrypted form. Therefore, when recovering the database user's password, temporarily set this parameter to true in the default profile of the restore destination. If the restore is successful, the contents of the default profile are restored to the contents at the time of the backup.
Recovery
If you recover using older backup data, you may be considered a dormant user at the time of recovery, or your password may have expired. In this case, unlock or change the password after recovery.
