On Sun, Dec 24, 2023 at 11:04 AM Johnathan Tiamoh <johnathantia...@gmail.com> 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.