From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Verify data after backup and restore
Date: Wed, 13 Dec 2023 15:17:11 +0100
Message-ID: <e4bcfd1e-b9c5-edff-a833-523bd76d1b40@jakobs.com> (raw)
In-Reply-To: <CAJk5AtZKvK+hVqYrgOWkwEPMiHetb8SV6Dd18_cW28fTKVEMcg@mail.gmail.com>
References: <CAJk5AtZKvK+hVqYrgOWkwEPMiHetb8SV6Dd18_cW28fTKVEMcg@mail.gmail.com>
Am 13.12.23 um 14:50 schrieb Rajesh Kumar:
> Hi all,
>
> What are all things I need to verify once I took backup and restore?
None, if backup and restore didn't show any errors.
But feel free to write a little program or script interating over all
tables in both databases to compare the values in them.
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../e4bcfd1e-b9c5-edff-a833-523bd76d1b40@jakobs.com/2-OpenPGP_signature)
download
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: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Verify data after backup and restore
In-Reply-To: <e4bcfd1e-b9c5-edff-a833-523bd76d1b40@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox