From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | jayati(dot)biswas(at)cmcltd(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: recovery with pg_xlog |
Date: | 2006-04-21 05:48:27 |
Message-ID: | 20060421054826.GX49405@pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 18, 2006 at 11:40:42AM +0530, jayati(dot)biswas(at)cmcltd(dot)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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-04-21 05:51:17 | Re: Query to check existence of stored procedure? |
Previous Message | sconeek | 2006-04-21 04:21:27 | Re: temp tables problem |