On Sun, Dec 24, 2023 at 11:04 AM Johnathan Tiamoh <johnathantiamoh@xxxxxxxxx> wrote:
If so how was the backup done?It was taken with a customized script that uses pg_dump.
That's your problem: pg_dump is a logical backup. All the WAL records are now completely invalid.
If you want PITR, read https://www.postgresql.org/docs/current/continuous-archiving.html and then use a dedicated PITR program.like (alphabetically) barman or pgbackrest.
I like pgbackrest. It's always worked for me, and the developers respond quickly to issues raised on github. Stephen also monitors this list.
