Re: compare two databases - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: compare two databases
Date
Msg-id 20031117165145.GS1716@libertyrms.info
Whole thread Raw
In response to Re: compare two databases  (Yuji Shinozaki <ys2n@virginia.edu>)
Responses Re: compare two databases
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Együd Csaba
Date:
Subject: Strange behavior after refreshing stored functions
Next
From: Reece Hart
Date:
Subject: Re: compare two databases