verifying data integrity after migrating for postgres 7.3 to postgres 8.1 - Mailing list pgsql-general

From Najib Abi Fadel
Subject verifying data integrity after migrating for postgres 7.3 to postgres 8.1
Date
Msg-id 20061020070335.91905.qmail@web38309.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
Hi,

i migrated my database from postgres 7.3 to postgres
8.1.

I was wondering if there is a way to verify that data
has been well copied betweeen the 2 versions !

I thought about writing a script that will verify that
we have the same tables and the same number of lines
per table between the 2 databases.

Has anyone done that before ?

Is there any other way for verification ?

Thanks in advance for any help.

Najib.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: trigger postgresql 7.4
Next
From: Naz Gassiep
Date:
Subject: Ghost open transaction