Re: transaction lost when delete clog file after normal shutdown

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: "章晨曦(at)易景科技" <zhangchenxi(at)halodbtech(dot)com>
Cc: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, 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:43:13
Message-ID: 1FD31D5E-A22C-4775-BD26-BDC9A3EE6304@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 23 Dec 2024, at 11:36, 章晨曦(at)易景科技 <zhangchenxi(at)halodbtech(dot)com> wrote:

> Human errors, disk errors, or even cosmic rays ...

That sounds exactly like the scenario which backups are made for. In all these
error cases there is no way of being sure that no other part of the system has
been compromised, so you restore from backup with WAL replay.

--
Daniel Gustafsson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2024-12-23 10:52:50 Re: transaction lost when delete clog file after normal shutdown
Previous Message 2024-12-23 10:36:38 Re: Re: transaction lost when delete clog file after normal shutdown