Re: recovery with pg_xlog

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: recovery with pg_xlog
Дата
Msg-id 20060421054826.GX49405@pervasive.com
обсуждение исходный текст
Ответ на recovery with pg_xlog  (jayati.biswas@cmcltd.com)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: sudo-like behavior
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Query to check existence of stored procedure?