Обсуждение: recovery with pg_xlog
We want to prepare a backup machine (for disaster management) by passing only the ARCHIVEDIR directory from another online machine - both the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR but the recovery is not successful unless we send the FULL DATA Directory. Is it possible,to doing such a procedure,if yes,then please tell me the steps. thanking you jayati biswas
On Tue, Apr 18, 2006 at 11:40:42AM +0530, jayati.biswas@cmcltd.com wrote: > We want to prepare a backup machine (for disaster management) by > passing only the ARCHIVEDIR directory from another online machine - both > the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR > but the recovery is not successful unless we send the FULL DATA Directory. > > Is it possible,to doing such a procedure,if yes,then please tell me the > steps. No. PITR (what you're describing) depends on having a *correct copy* of PGDATA available. You should read up about PITR at http://www.postgresql.org/docs/8.1/interactive/backup-online.html -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461