Quick Links

How to validate restore of backup?

From:	Vince McMahon <sippingonesandzeros(at)gmail(dot)com>
To:	"pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:	How to validate restore of backup?
Date:	2024-08-22 11:06:00
Message-ID:	CAKS+vVZSg=LDpFThxZQyemYE470Hbb15W-YZDHv=-fEZjML2QA@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi,

I have some questions When doing pg_restore of backup of a database to a
NEW server.

Is there a way to ensure the data integrity is in tact, and user ID and
access works liked how it was in the old server?

How to properly handle the materialized views when backing up and restoring?

Thanks.

Re: How to validate restore of backup? at 2024-08-22 11:09:47 from Muhammad Usman Khan
Re: How to validate restore of backup? at 2024-08-22 11:21:52 from Ron Johnson
Re: How to validate restore of backup? at 2024-08-22 15:36:32 from Adrian Klaver

	From	Date	Subject
Next Message	Muhammad Usman Khan	2024-08-22 11:09:47	Re: How to validate restore of backup?
Previous Message	Lok P	2024-08-22 07:25:48	Re: Column type modification in big tables