pgbackrest - question about restoring cluster to a new cluster on same server

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgbackrest - question about restoring cluster to a new cluster on same server
Date: 2019-09-18 22:59:34
Message-ID: 0c037137-9480-3afa-a4b7-1400a9879cd2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

(Thanks, Stephen, for helping with my earlier problem.)

Scenario: there's data corruption on production server, so we need to do a
PITR restore from "a few days ago" of the cluster holding the prod databases
to a second cluster on that same VM in order to try and find the missing
data and load it back into the prod cluster.

Other than putting a high I/O load on the LUN where repo-path is located
(from both writing WALs to it and reading the backed up files), will there
be any problems when "pg_ctl start" processes recovery.conf and applies the
WAL files to the new cluster while the prod cluster is writing new WAL files.

Does my question make sense?

Thanks
--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2019-09-18 23:03:02 Re: PostgreSQL License
Previous Message Ron 2019-09-18 22:20:14 Re: PostgreSQL License