Re: transaction lost when delete clog file after normal shutdown

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: "章晨曦(at)易景科技" <zhangchenxi(at)halodbtech(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Junwang Zhao <zhjwpku(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: transaction lost when delete clog file after normal shutdown
Date: 2024-12-23 10:52:50
Message-ID: 2686A6CE-3911-4B3F-9E2B-09CAE7FD2108@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 23 Dec 2024, at 15:36, 章晨曦(at)易景科技 <zhangchenxi(at)halodbtech(dot)com> wrote:
>
> disk errors, or even cosmic rays ...

It is file system responsibility to protect directory structure.

> Human errors,

We cannot protect database from this with technical measures. I concur with Tom about firing DBA who removed xact log file.

Best regards, Andrey Borodin.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 2024-12-23 11:01:01 Re: Re: transaction lost when delete clog file after normal shutdown
Previous Message Daniel Gustafsson 2024-12-23 10:43:13 Re: transaction lost when delete clog file after normal shutdown