Re: Re: transaction lost when delete clog file after normal shutdown

[章晨曦@易景科技]

Yes, of course we can solve this by restoring from backup. 
But if the database volumn is large, say, 100TB or more, the cost
is really too expensive just because the tiny clog file corrupt.


Regards,
Jet


                    Daniel Gustafsson<dan...@yesql.se&gt;&nbsp;在 2024年12月23日 周一 
18:43 写道：

&gt; On 23 Dec 2024, at 11:36, 章晨曦@易景科技 <zhangche...@halodbtech.com&gt; wrote:

&gt; Human errors, disk errors, or even cosmic rays ...

That sounds exactly like the scenario which backups are made for.&nbsp; 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