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

From David G. Johnston
Subject Re: Need help with PITR for PostgreSQL 9.4.5
Date
Msg-id CAKFQuwabUucmjzB2uyoq31qM4pcgP_rOGMQ4jA5P+itCDE9Xxw@mail.gmail.com
Whole thread Raw
In response to Need help with PITR for PostgreSQL 9.4.5  (Sri Linux <srilinux09@gmail.com>)
Responses Re: Need help with PITR for PostgreSQL 9.4.5
List pgsql-general
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 by date:

Previous
From: Sri Linux
Date:
Subject: Need help with PITR for PostgreSQL 9.4.5
Next
From: Rajnish Vishwakarma
Date:
Subject: Error in Table Creation