Re: WAL restoration is not happening completely

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: WAL restoration is not happening completely
Дата
Msg-id 20161114175509.3wgvxos44hxxz26i@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: WAL restoration is not happening completely  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: WAL restoration is not happening completely  (rajan <vgmonnet@gmail.com>)
Список pgsql-admin
On 2016-11-14 08:58:14 -0500, Peter Eisentraut wrote:
> On 11/14/16 4:49 AM, rajan wrote:
> > *The restored database has changes which were done today and missing data
> > from changes did a couple of days before.*
>
> That is pretty much impossible.
>
> It is plausible to mess some of this up and end up with a database
> instance that is missing the trailing end of changes because recovery
> aborted early somehow.  But missing changes *in the middle* is not
> possible, unless you are encountering a serious bug.

Could quite well be a restore with a deleted backup_label - that tends
to cause symptoms like that.

Rajan, did you by chance delete backup_label?

Regards,

Andres


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

Предыдущее
От: Poul Kristensen
Дата:
Сообщение: C code with embedded SQL
Следующее
От: John Scalia
Дата:
Сообщение: hostnossl in pg_hba.conf demands a password