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