Re: How do i compare 2 postgresql instanses ?
| От | Michael Nacos |
|---|---|
| Тема | Re: How do i compare 2 postgresql instanses ? |
| Дата | |
| Msg-id | 407fa4640807080620r33a3463fgff195d8ae5ef708e@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How do i compare 2 postgresql instanses ? (Achilleas Mantzios <achill@matrix.gatewaynet.com>) |
| Ответы |
Re: How do i compare 2 postgresql instanses ?
|
| Список | pgsql-admin |
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
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
В списке pgsql-admin по дате отправления: