Search Postgresql Archives

Re: How to validate restore of backup?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux