From: | Muhammad Usman Khan <usman(dot)k(at)bitnine(dot)net> |
---|---|
To: | Vince McMahon <sippingonesandzeros(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How to validate restore of backup? |
Date: | 2024-08-22 11:09:47 |
Message-ID: | CAPnRvGsmb57R7cD3KFjN6p=YrxXen-E_Xbs9QKHx7REKQfz--g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Vince,
For validation of databases, you can use the following approach
/usr/pgsql-16/bin/pg_dump -d postgres -h localhost -p 5428 | md5sum >
/var/lib/pgsql/db1.txt
/usr/pgsql-16/bin/pg_dump -d postgres -h localhost -p 5420 | md5sum >
/var/lib/pgsql/db2.txt
diff db1.txt db2.txt
By executing above queries, if diff is null then it means there is no
difference between source and destination databases. Adjust your port and
databases accordingly.
On Thu, 22 Aug 2024 at 16:06, Vince McMahon <sippingonesandzeros(at)gmail(dot)com>
wrote:
> 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-08-22 11:21:52 | Re: How to validate restore of backup? |
Previous Message | Vince McMahon | 2024-08-22 11:06:00 | How to validate restore of backup? |