Re: restoring wal archive and pg_xlog dir

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: restoring wal archive and pg_xlog dir
Дата
Msg-id Pine.LNX.4.63.0506231600320.21285@discord.dyndns.org
обсуждение исходный текст
Ответ на Re: restoring wal archive and pg_xlog dir  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: restoring wal archive and pg_xlog dir  (Jeff Frost <jeff@frostconsultingllc.com>)
Список pgsql-admin
On Thu, 23 Jun 2005, Simon Riggs wrote:

> That was the bit I thought of. The files are streamed in one by one using a
> temp filename, so you never run out of space no matter how big the archive
> of transaction logs. Thats an important feature if a base backup goes bad
> and you have to go back to n-1 base backup.

I guess I forgot to ask one other question.  If the archived wal files are
streamed in one by one, would it still be safe to leave the pg_xlog directory
intact in the base backup?  What would happen with the out of date log files?
Would they just stay in place or would the postmaster eventually recycle them
after the restore was complete?


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

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

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: restoring wal archive and pg_xlog dir
Следующее
От: David Bear
Дата:
Сообщение: stupid insert error