Re: compare two databases

On Sun, Nov 16, 2003 at 09:46:08AM -0500, Yuji Shinozaki wrote:
>
> Here's a question about that:  Do dumps always occur
> in a predictable row order?

No, at least not between systems.  I'm pretty sure that the same
system, if left unchanged between them, wil dump the tables in the
same order.  They key to all this is understanding the implications
of lazy vacuum: tuples do not always stay in the same place on the
disk.

> If it is not the case, then you might need to sort each
> table dump before the diff.

Yes.

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110