Ron <ronljohnsonjr@xxxxxxxxx> writes: > 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. There should be no issues *if* you have insured that the 2 server configurations do not overlap each other in any way. HTH > Does my question make sense? > > Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx
