Need help with PITR for PostgreSQL 9.4.5

Поиск
Список
Период
Сортировка
От Sri Linux
Тема Need help with PITR for PostgreSQL 9.4.5
Дата
Msg-id CAFcfow9mkj8u6oAsKxniZsCkH-i_f5b9_1OTtkP6=4sjww8cjg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need help with PITR for PostgreSQL 9.4.5  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi All,

I am trying to do PINT backup and recovery for the standalone database which is not in a cluster. 

recovery.done is created, after restart database is having errors to start "

< 2020-06-22 16:34:08.280 CDT >LOG:  starting archive recovery
< 2020-06-22 16:34:08.456 CDT >LOG:  restored log file "000000010000000000000001" from archive
< 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.
< 2020-06-22 16:34:08.487 CDT >LOG:  invalid primary checkpoint record


Please suggest me right method to backup and restore for RHEL OS.


Thanks and Regards
Deepthi


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

Предыдущее
От: Tim Cross
Дата:
Сообщение: Re: Persistent Connections
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Need help with PITR for PostgreSQL 9.4.5