Re: WAL archiving disaster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL archiving disaster
Дата
Msg-id 20370.1302655238@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WAL archiving disaster  (Mike Atkin <mike.atkin@gmail.com>)
Список pgsql-admin
Mike Atkin <mike.atkin@gmail.com> writes:
> So... normally this would be curtains for the database but the missing
> segment is from a 4 hour period of practically zero activity.  It was
> only archived because it hit the archive_timeout.  Is there any way I
> can force postgres to ignore this segment and attempt to redo the rest
> of the logs.  I realise this may leave the database terminally
> inconsistent but my focus is on retrieving as much of the data as
> possible for re-entry rather than getting a functional system out the
> other end.

If you're willing to assume there were no updates in that interval,
you could try generating a dummy WAL segment having the correct page
headers and no contents except an XLOG_SWITCH record.  I don't know
of any handy tools for that unfortunately.

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Missing documentation for error code: 80S01
Следующее
От: bkwiencien
Дата:
Сообщение: Re: Intallation of postgres 9.0.3 gives an error on already installed postgres 8.4 on the same machine