Re: [HACKERS] Orphaned files in base/[oid]

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: [HACKERS] Orphaned files in base/[oid]
Дата
Msg-id CAN-RpxA1NwmfQ_MboT=v=KuSBvc=1xwdp76trr4VxvGH48bizA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Orphaned files in base/[oid]  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения


On Wed, Aug 16, 2017 at 7:15 PM, Andres Freund <andres@anarazel.de> wrote:


I think this entirely is the wrong approach.  We shouldn't add weird
check commands that require locks on pg_class, we should avoid leaving
the orphaned files in the first place.  I've upthread outlined
approached how to do so.

And in the mean time I suppose there is no reason that the approach I have outlined cannot be used by an external program.    I think it is sane to draw the line at having the db responsible for cleaning up after itself when something goes wrong and leave external programs to do after-the-fact review and cleanup. 

Greetings,

Andres Freund



--
Best Regards,
Chris Travers
Database Administrator

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com 
Saarbrücker Straße 37a, 10405 Berlin

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] Quorum commit for multiple synchronous replication.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Quorum commit for multiple synchronous replication.