public inbox for [email protected]
help / color / mirror / Atom feedFrom: Murthy Nunna <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: RE: Running rsync backups in pg15
Date: Sun, 10 Nov 2024 15:05:21 +0000
Message-ID: <DM8PR09MB6677B05D9D3C83518E9C27E8B85F2@DM8PR09MB6677.namprd09.prod.outlook.com> (raw)
In-Reply-To: <[email protected]>
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]>
Thanks, Laurenz. I appreciate your explanation.
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. But I see this case as a user who is deliberately corrupting the server. There are tons of scenarios to corrupt a database from outside postgres. Postgres cannot be responsible for these type of user introduced corruptions.
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.
-----Original Message-----
From: Laurenz Albe <[email protected]>
Sent: Saturday, November 9, 2024 11:34 PM
To: Murthy Nunna <[email protected]>; Pgsql-admin <[email protected]>
Subject: Re: Running rsync backups in pg15
You would normally end up with data corruption or an error if you removed "backup_label"
from a properly taken backup. Manually removing "backup_label" is dangerous. It is safe to do if the server crashed while in exclusive backup mode, but it is detrimental anywhere else.
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]
Subject: RE: Running rsync backups in pg15
In-Reply-To: <DM8PR09MB6677B05D9D3C83518E9C27E8B85F2@DM8PR09MB6677.namprd09.prod.outlook.com>
* 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