Re: Running rsync backups in pg15 - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Running rsync backups in pg15
Date
Msg-id 2ae3d790ba228a62c97a40a419c3d05890952b11.camel@cybertec.at
Whole thread Raw
In response to RE: Running rsync backups in pg15  (Murthy Nunna <mnunna@fnal.gov>)
Responses RE: Running rsync backups in pg15
List pgsql-admin
On Sun, 2024-11-10 at 15:05 +0000, Murthy Nunna wrote:
> So, in the test case that Fujii sent, the server crashed during backup so it was safe to remove "backup_label".
>
> However, in case of a completed exclusive backup, if you remove "backup_label" and then try to bring up server
> using the same backed up data as PGDATA, then you will have corrupted server. I get it.
>
> In my humble opinion with respect to all, if this is the only reason (removing "backup_label" thus introducing
> corruption) for removing exclusive backups, I think it is an oversight by the Postgres Development Group
> approving this change.

The other reason is that in this day of automation it is unappealing that there is a case where a
crashed server cannot start without manual intervention.  And automating the removal of "backup_label"
is not a good idea...

But I see your point, and I argued similarly when the exclusive backup mode was removed.
However, the majority disagreed.

See the discussion in
https://www.postgresql.org/message-id/flat/ac7339ca-3718-3c93-929f-99e725d1172c%40pgmasters.net

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Re: How to check if session is a hung thread/session
Next
From:
Date:
Subject: RE: How to check if session is a hung thread/session