[ please refrain from top-quoting, and try not to repeat the entire
previous post; we do have archives you know ]
Rick Gigger <rick@alpinenetworking.com> writes:
> On Feb 9, 2006, at 1:03 PM, Philippe Ferreira wrote:
>> Do a "pgdump" of both databases, and use the "diff" tool to compare
>> the two generated files !
> Is the ordering guaranteed to be the same on both boxes if you do this?
For recent pg_dumps (since 8.0 I think) it should be the same as long
as both DBs are actually identical. If there are different interobject
dependencies, that might force different dump orders.
regards, tom lane