Re: [PATCH] Recreate Missing WAL Directories (from TODO)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Recreate Missing WAL Directories (from TODO)
Дата
Msg-id 23860.1226178538@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [PATCH] Recreate Missing WAL Directories (from TODO)  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: [PATCH] Recreate Missing WAL Directories (from TODO)  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: [PATCH] Recreate Missing WAL Directories (from TODO)  (Decibel! <decibel@decibel.org>)
Список pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> When performing a PITR copy of a data cluster, the pg_xlog directory
> is generally omitted.  As such, when starting the copy up for
> replay/recovery, the WAL directories need to be recreated.  This patch
> checks to see whether XLOGDIR and XLOGDIR/archive_status exist on
> XLOGStartup and if not, recreates them.

This has been suggested before but I'm unconvinced that it's a good
idea.  It's reasonably common for pg_xlog to be a symlink.  If you
neglect to re-establish the symlink then what would happen is that xlog
gets recreated on the data disk, and with no notice you are running in
a degraded mode.

It might be reasonable to auto-recreate XLOGDIR/archive_status, though.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: [PATCH] Recreate Missing WAL Directories (from TODO)