Re: Re: [BUGS] BUG #4796: Recovery followed by backup creates unrecoverable WAL-file

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Re: [BUGS] BUG #4796: Recovery followed by backup creates unrecoverable WAL-file
Дата
Msg-id 1241717603.6109.319.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Re: [BUGS] BUG #4796: Recovery followed by backup creates unrecoverable WAL-file  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Re: [BUGS] BUG #4796: Recovery followed by backup creates unrecoverable WAL-file  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Thu, 2009-05-07 at 18:57 +0300, Heikki Linnakangas wrote:
> I don't see any user error here.

Just observing that the error occurs because we rely on a file being
there when we haven't even documented that it needs to be there for it
to work. File deletion with %r from the archive would not have removed
that file at that point. We should have an explicit statement about
which files can be deleted from the archive and which should not be, but
in general it is dangerous to remove files that have not been explicitly
described as removable.

Playing with the order of events seems fragile and I would prefer a more
explicit solution. Recording the timeline history permanently with each
server would be a sensible and useful thing (IIRC DB2 does this).

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Serializable Isolation without blocking
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Serializable Isolation without blocking