Re: Re: transaction lost when delete clog file after normal shutdown - Mailing list pgsql-hackers

From 章晨曦@易景科技
Subject Re: Re: transaction lost when delete clog file after normal shutdown
Date
Msg-id tencent_353C0DDF6AAE2C4F41D38295@qq.com
Whole thread Raw
In response to transaction lost when delete clog file after normal shutdown  ("章晨曦@易景科技" <zhangchenxi@halodbtech.com>)
Responses Re: transaction lost when delete clog file after normal shutdown
Re: transaction lost when delete clog file after normal shutdown
List pgsql-hackers
Human errors, disk errors, or even cosmic rays ...

Regards,
Jet

Andrey Borodin<x4mmm@yandex-team.ru> 在 2024年12月23日 周一 18:15 写道:


> On 23 Dec 2024, at 15:03, 章晨曦@易景科技 <zhangchenxi@halodbtech.com> wrote:
>
> S1:
> When database normal shutdown, and clog file missing, the database cannot restart. And if make a zero clog file, database started but may cause transactions lost.
>
> S2:
> When database crashed, and  clog file missing, when database restart, it will try to recover. And everything is ok
>
> So I think we may improve the database more reliable in some scenarios, e.g. Only clog file corrupted or missing, like S1

I still do not get it. Why clog file would be missing?


Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: transaction lost when delete clog file after normal shutdown
Next
From: Daniel Gustafsson
Date:
Subject: Re: transaction lost when delete clog file after normal shutdown