Re: Need help with PITR for PostgreSQL 9.4.5

Поиск
Список
Период
Сортировка
От Sri Linux
Тема Re: Need help with PITR for PostgreSQL 9.4.5
Дата
Msg-id CAFcfow-sD=D591oyV_gmZiEDC1gO7EZVS60ksUh0ChsbE0N8Zw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help with PITR for PostgreSQL 9.4.5  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Need help with PITR for PostgreSQL 9.4.5  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Дерево обсуждения
Thank you all for the response,

Please find the method used. Please recommend me if I have done something wrong...


Thanks and Regards,
sree

On Wed, Jun 24, 2020 at 11:36 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
The version you are running is neither up-to-date for its major version (9.4) nor is the major version being supported.


Thoug a functioning backup is good to have before upgrading, especially major versions.

On Wednesday, June 24, 2020, Sri Linux <srilinux09@gmail.com> wrote:
I am trying to do PINT backup and recovery for the standalone database which is not in a cluster. 

That is not possible.  Its unclear what exactly you mead/did though.  Consider sharing actual commands/scripts.

< 2020-06-22 16:34:08.487 CDT >LOG:  WAL file is from different database system: WAL file database system identifier is 6840038030519879233, pg_control database system identifier is 6841285371464745049.

You cannot PITR if the WAL doesn’t match the base backup for the cluster you are trying to restore.


Or, probably better, consider using a third-party system.

David J.

Вложения

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: n_distinct off by a factor of 1000
Следующее
От: Matthias Apitz
Дата:
Сообщение: Re: error messages (autovaccum canceled and syntax errors) whileloading a DUMP