Re: Unable to start postgresql-14

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Unable to start postgresql-14
Дата
Msg-id CANzqJaCgpPtteYUKKc=fWj6w-grEk=zqX6vedcObh44U0CbeaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unable to start postgresql-14  (Johnathan Tiamoh <johnathantiamoh@gmail.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Unable to start postgresql-14
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Changing a schema's name with function1 calling function2