Postgres Pro
Downloads
Home   >   mailing lists

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

From Rajesh Kumar
Subject Re: Verify data after backup and restore
Date
Msg-id CAJk5AtZxqp9MzCJ2yKep8VvsYGZMRKzCMOyOtst1=GhFu5UYyw@mail.gmail.com
Whole thread Raw
In response to Re: Verify data after backup and restore  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Verify data after backup and restore
List pgsql-admin
Tree view
Backup and restore I mean during downtime only. I wanted to double check what all things we need to validate after a successful restore. Like table count , all 14 objects count, first and last row of important tables, row count of each table like dat?

On Wed, 13 Dec, 2023, 8:48 PM Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Wed, Dec 13, 2023 at 10:16 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
checking the backup files for size, date, and format; utilizing checksums or hashes to compare the backup files with the original data files

 How does that work on constantly changing tables?

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Reindex concurrently
Next
From: SOzcn
Date:
Subject: Re: Reindex concurrently