Add system identifier to backup manifest

From: Amul Sul <sulamul(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Add system identifier to backup manifest
Date: 2024-01-17 11:30:52
Message-ID: CAAJ_b948iB9mGYWYA0BobggC+_HkcQSe94p8t5Ut94NJxqKN6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

With the attached patch, the backup manifest will have a new key item as
"System-Identifier" 64-bit integer whose value is derived from pg_control
while
generating it, and the manifest version bumps to 2.

This helps to identify the correct database server and/or backup for the
subsequent backup operations. pg_verifybackup validates the manifest system
identifier against the backup control file and fails if they don’t match.
Similarly, pg_basebackup increment backup will fail if the manifest system
identifier does not match with the server system identifier. The
pg_combinebackup is already a bit smarter -- checks the system identifier
from
the pg_control of all the backups, with this patch the manifest system
identifier also validated.

For backward compatibility, the manifest system identifier validation will
be
skipped for version 1.

--
Regards,
Amul Sul
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
v1-0001-Add-system-identifier-to-backup-manifest.patch application/x-patch 30.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2024-01-17 11:45:05 Re: Add system identifier to backup manifest
Previous Message Shubham Khanna 2024-01-17 10:50:22 Re: [PATCH] Compression dictionaries for JSONB