| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: compare two databases |
| Date: | 2003-11-17 16:51:46 |
| Message-ID: | 20031117165145.GS1716@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reece Hart | 2003-11-17 17:51:55 | Re: compare two databases |
| Previous Message | Együd Csaba | 2003-11-17 14:36:07 | Strange behavior after refreshing stored functions |