Re: Deleting a table file does not raise an error when the table is touched afterwards, why?
От
Simon Riggs
Тема
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why?
Дата
Msg-id
CANP8+jLNL4xdQstx8yQc1iOZ63eA06E-_sihMrhm8gNX=F5HxQ@mail.gmail.com
Ответ на
Deleting a table file does not raise an error when the table is
touched afterwards, why? (Daniel Westermann)
Список
Дерево обсуждения
Deleting a table file does not raise an error when the table is
touched afterwards, why? Daniel Westermann <daniel.westermann@dbi-services.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? Alex Ignatov <a.ignatov@postgrespro.ru>
Re: Deleting a table file does not raise an error when the table is touched afterwards, why? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? David W Noon <david.w.noon@googlemail.com>
Re: Deleting a table file does not raise an error when
the table is touched afterwards, why? Daniel Westermann <daniel.westermann@dbi-services.com>
Re: Deleting a table file does not raise an error when the table is touched afterwards, why? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Deleting a table file does not raise an error when
the table is touched afterwards, why? Daniel Westermann <daniel.westermann@dbi-services.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? Francisco Olarte <folarte@peoplecall.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? David W Noon <david.w.noon@googlemail.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? Francisco Olarte <folarte@peoplecall.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? Simon Riggs <simon@2ndQuadrant.com>
Re: Deleting a table file does not raise an error when the
table is touched afterwards, why? Melvin Davidson <melvin6925@gmail.com>
On 30 May 2016 at 16:35, Daniel Westermann <daniel.westermann@dbi-services.com> wrote:
It's a very good thing that we remain flying even with multiple bullet holes in the wings.
--
...
Then I delete the file:
...
No issue in the log. This is probably coming from the cache, isn't it? Is this intended and safe?
Postgres manages your data for you. What you're doing is not a supported use case and I recommend not to do that in the future.
Can someone please tell me the intention behind that? From my point of view this is dangerous. If nobody is monitoring the log (which sadly is the case in reality) nobody will notice that only parts of the table are there. Wouldn't it be much more safe to raise an error as soon as the table is touched?
How would we know that an external agent had deleted the file? What action should we take if we did notice?
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-general по дате отправления
От: Francisco Olarte
Дата:
