Re: Verify data after backup and restore

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Subject: Re: Verify data after backup and restore
Date: 2023-12-13 15:16:27
Message-ID: 1724011802.839581.1702480587361@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

reviewing the backup logs and reports for any errors, warnings, or failures; checking the backup files for size, date, and format; utilizing checksums or hashes to compare the backup files with the original data files and performing a test restore on a separate server or environment to confirm that the backup files are readable and restorable.

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Wednesday, December 13, 2023 at 08:51:15 AM EST, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:

Hi all,
What are all things I need to verify once I took backup and restore?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2023-12-13 15:18:45 Re: Verify data after backup and restore
Previous Message jacob ndinkwa 2023-12-13 14:38:55 Re: Setup HA in PostgreSQL 15?