Re: replay WAL segments without a "base backup" ?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: replay WAL segments without a "base backup" ?
Дата
Msg-id 4A814CA0020000250002987F@gw.wicourts.gov
обсуждение исходный текст
Ответ на replay WAL segments without a "base backup" ?  (Kevin Kempter <kevink@consistentstate.com>)
Список pgsql-admin
Kevin Kempter <kevink@consistentstate.com> wrote:

> We did a restore with a pgdump

> do have WAL segments

> Is there any way to trick postgres into thinking that it needs to
> play fwd these WAL's?

No.  pg_dump SELECTs data at the row level and WAL files are at the
page level.  The two techniques aren't compatible in that way.

Theoretically, if you could determine the oids of all the objects in
the old database, through examination of the WAL files, you might be
able to work through the WAL files and recover some data, but it would
be a massive amount of work.

At this point, if you have source documents, logs, or any other
peripheral source of data it is likely to be less work to recover that
way.

In case is is not already obvious, you should never consider that you
have a working backup system without testing a restore onto another
machine.

-Kevin

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

Предыдущее
От: Greg Spiegelberg
Дата:
Сообщение: Re: replay WAL segments without a "base backup" ?
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: Max connections