Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniel Gustafsson
Subject Re: transaction lost when delete clog file after normal shutdown
Date
Msg-id 1FD31D5E-A22C-4775-BD26-BDC9A3EE6304@yesql.se
Whole thread Raw
In response to Re: Re: transaction lost when delete clog file after normal shutdown  ("章晨曦@易景科技" <zhangchenxi@halodbtech.com>)
List pgsql-hackers
Tree view 
> On 23 Dec 2024, at 11:36, 章晨曦@易景科技 <zhangchenxi@halodbtech.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

pgsql-hackers by date:

Previous
From: "章晨曦@易景科技"
Date:
Subject: Re: Re: transaction lost when delete clog file after normal shutdown
Next
From: Andrey Borodin
Date:
Subject: Re: transaction lost when delete clog file after normal shutdown