Home > mailing lists

Re: Unable to start postgresql-14 - Mailing list pgsql-general

From	Ron Johnson
Subject	Re: Unable to start postgresql-14
Date	December 24, 2023 19:28:02
Msg-id	CANzqJaCgpPtteYUKKc=fWj6w-grEk=zqX6vedcObh44U0CbeaQ@mail.gmail.com Whole thread Raw
In response to	Re: Unable to start postgresql-14 (Johnathan Tiamoh <johnathantiamoh@gmail.com>)
List	pgsql-general

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

From: Adrian Klaver
Date: 24 December 2023, 19:27:21
Subject: Re: Unable to start postgresql-14

From: "Peter J. Holzer"
Date: 25 December 2023, 00:43:32
Subject: Re: Changing a schema's name with function1 calling function2