public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Murthy Nunna <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Running rsync backups in pg15
Date: Mon, 11 Nov 2024 14:00:33 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <DM8PR09MB6677B05D9D3C83518E9C27E8B85F2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <CANzqJaCr-id_4YotukPeH=rHCELS58Z63FoEbkNFBSqzjGMueQ@mail.gmail.com>
<01000193082d1077-34d9461d-49e4-44ef-b83a-0201df4fc0ba-000000@email.amazonses.com>
<DM8PR09MB6677705AE81436745B4487F6B85C2@DM8PR09MB6677.namprd09.prod.outlook.com>
<CANzqJaA02zeZTUB=uFPfxgJ+=NUUy1cQP3E0=3u0ssHdL6qkMA@mail.gmail.com>
<DM8PR09MB6677F19E2DDD6E18A4FDE2D6B85D2@DM8PR09MB6677.namprd09.prod.outlook.com>
<CANzqJaBZ+j2o8jQ8Hs63AQbAZfiFcyApa5d212A1LNkagqyrGQ@mail.gmail.com>
<DM8PR09MB66779BE5DA062DFB7257BE96B85D2@DM8PR09MB6677.namprd09.prod.outlook.com>
<[email protected]>
<DM8PR09MB667799AD3A5C891C2264A3AFB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
<[email protected]>
<DM8PR09MB6677B05D9D3C83518E9C27E8B85F2@DM8PR09MB6677.namprd09.prod.outlook.com>
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
view thread (24+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Running rsync backups in pg15
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox