pgbackrest - question about restoring cluster to a new cluster onsame server

Поиск
Список
Период
Сортировка
От Ron
Тема pgbackrest - question about restoring cluster to a new cluster onsame server
Дата
Msg-id 0c037137-9480-3afa-a4b7-1400a9879cd2@gmail.com
обсуждение
Ответы Re: pgbackrest - question about restoring cluster to a new cluster on same server
Re: pgbackrest - question about restoring cluster to a new cluster onsame server
Список 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.



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