PITR based recovery in a primary/standby cluster setup

From: Abhijit Gharami <abhijitgharami(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: PITR based recovery in a primary/standby cluster setup
Date: 2019-05-21 08:57:45
Message-ID: CAA5_DuBNyGuF7rFW+Me=VewfhQokTqsbdwds=hC_4Pqrgo6iqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We have primary and standby PostgreSQL cluster setup and also we have PITR
enabled on it. To improve the recovery time we are thinking of recovering
the database to both primary and standby at the same time.

These are the steps we are following:
1. Restore the base backup to the both primary and standby server
2. Replay the WAL files on both primary and standby and once the recovery
target is reached stop the servers
3. Start one of the server as Primary and other one as standby

We have followed the above steps but when we are trying to start the
servers as primary and standby we are having replication issues.

Could you please suggest what should be done here so that we can recover
the database in both primary as well as in standby server?

We are using PostgrerSQL version: 9.6.12 and for PITR we are using WAL-E.

Regards,
Abhijit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daulat Ram 2019-05-21 12:42:32 no matching entries in passwd file
Previous Message Ron 2019-05-21 00:54:27 Re: Loading table with indexed jsonb field is stalling