Re: Verify data after backup and restore

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Verify data after backup and restore
Date: 2023-12-13 14:17:11
Message-ID: e4bcfd1e-b9c5-edff-a833-523bd76d1b40@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message jacob ndinkwa 2023-12-13 14:38:55 Re: Setup HA in PostgreSQL 15?
Previous Message Rajesh Kumar 2023-12-13 13:50:35 Verify data after backup and restore