Re: possible bug: orphaned files left after immediate shutdown during DDL

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: possible bug: orphaned files left after immediate shutdown during DDL
Дата
Msg-id 1297311247.27157.486.camel@jdavis
обсуждение исходный текст
Ответ на Re: possible bug: orphaned files left after immediate shutdown during DDL  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: possible bug: orphaned files left after immediate shutdown during DDL
Список pgsql-bugs
On Wed, 2011-02-09 at 22:58 -0500, Tom Lane wrote:
> It's intentional ... not that other people haven't complained about it
> before.  Remember that what you have done is forced a crash, and
> recovery from it is crash recovery.  If we proactively removed such
> files we would very possibly be destroying evidence of forensic value.

I thought that might be the case, but I wasn't able to find any previous
discussions.

It might be a good idea to issue a warning during recovery, however,
like "possible orphaned file ...". I'm not sure if it's worth the
bookkeeping effort though.

Regards,
    Jeff Davis

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: possible bug: orphaned files left after immediate shutdown during DDL
Следующее
От: Andres Freund
Дата:
Сообщение: crash in 9.1's psql:describeOneTableDetails