Re: Verify data after backup and restore

Try it, and find out.

On Thu, Dec 14, 2023 at 12:08 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:

> Can I get the row count directly from pg_stat_user_indexes?
>
> On Thu, 14 Dec 2023, 10:25 Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>>
>> If you think that "grep -E 'ERROR:|WARN:' pg_dump_$DB.log" is
>> insufficient, then write a script to get MIN(), MAX() and COUNT(*) of each
>> table before you do a pg_dump. After pg_restore, run the same script, but
>> pointed at the new database.
>>
>> SELE the "first" (presumably ordered by primary key) and "last" records
>> On Wed, Dec 13, 2023 at 1:49 PM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
>> wrote:
>>
>>> 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?
>>>>
>>>>