Re: recovery with pg_xlog

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