Many operations take an archive file for recovery and discard the previous archive file once it has been backed up.
However, if an archive file containing userlogs previously inserted by a transaction that is running at some point is destroyed, the complete extract file cannot be created.
To avoid this, see the required_filename column of the pgx_stat_userlog view and remove any earlier archive files.
Note
Do not use the pgx_dumpall command. This command automatically deletes archived files prior to the backup after the backup.
When deleting an instance's archive file, do not use the file name from the pgx_stat_userlog view of the other instance. There is a slight time difference and the archive file may still be needed.
