Postgres Pro
Downloads
Home   >   mailing lists

Need help with PITR for PostgreSQL 9.4.5 - Mailing list pgsql-general

From Sri Linux
Subject Need help with PITR for PostgreSQL 9.4.5
Date
Msg-id CAFcfow9mkj8u6oAsKxniZsCkH-i_f5b9_1OTtkP6=4sjww8cjg@mail.gmail.com
Whole thread Raw
Responses Re: Need help with PITR for PostgreSQL 9.4.5  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Tim Cross
Date:
Subject: Re: Persistent Connections
Next
From: "David G. Johnston"
Date:
Subject: Re: Need help with PITR for PostgreSQL 9.4.5