Re: Verify data after backup and restore

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pepe TD Vo <pepevo(at)yahoo(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Verify data after backup and restore
Date: 2023-12-13 18:49:36
Message-ID: CAJk5AtZxqp9MzCJ2yKep8VvsYGZMRKzCMOyOtst1=GhFu5UYyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)com> wrote:

> On Wed, Dec 13, 2023 at 10:16 AM Pepe TD Vo <pepevo(at)yahoo(dot)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?
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message SOzcn 2023-12-13 18:52:02 Re: Reindex concurrently
Previous Message David G. Johnston 2023-12-13 18:46:04 Re: Reindex concurrently