From: Michael Nacos <m.nacos@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: How do i compare 2 postgresql instanses ?
Date: Tue, 8 Jul 2008 14:20:58 +0100
Message-ID: <407fa4640807080620r33a3463fgff195d8ae5ef708e@mail.gmail.com> (raw)
In-Reply-To: <200807081602.39336.achill@matrix.gatewaynet.com>
References: <49982.1215520948@ismartpanache.com>
<200807081602.39336.achill@matrix.gatewaynet.com>
Hello there. Simple counts can certainly prove two databases are not the
same version. But what if you actually want to look at the data? I have been
thinking about row checksums, would you say this would be a reasonable way
of verifying two databases are equivalent? I have many other things on my
mind, so I haven't tried implementing this yet.
Michael
> you could write a little program (awk) to produce an sql file of the form:
> select count(*) from airlines;
> select count(*) from airports;
> select count(*) from airticket;
> select count(*) from airticketflights;
> ....
> select count(*) from zzzobjects;
>
> and then run it against the two databases, and diff the outputs.
> If the outputs are not identical then you have 2 different databases,
> otherwise you have to search more to know the answer.
> So this technique can prove that yours DBs are *not* identical, but does
> not say anything
> about the opposite.
>
> --
> Achilleas Mantzios
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: m.nacos@gmail.com
Subject: Re: How do i compare 2 postgresql instanses ?
In-Reply-To: <407fa4640807080620r33a3463fgff195d8ae5ef708e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox