Postgres Pro
Downloads
Home   >   mailing lists

Re: Verify data after backup and restore - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Verify data after backup and restore
Date
Msg-id e4bcfd1e-b9c5-edff-a833-523bd76d1b40@jakobs.com
Whole thread Raw
In response to Verify data after backup and restore  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Verify data after backup and restore
Next
From: jacob ndinkwa
Date:
Subject: Re: Setup HA in PostgreSQL 15?