| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rick Gigger <rick(at)alpinenetworking(dot)com> |
| Cc: | Philippe Ferreira <phil(dot)f(at)worldonline(dot)fr>, Nicholas Walker <nick(at)howsmymusic(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database Comparison tool? |
| Date: | 2006-02-10 14:47:42 |
| Message-ID: | 12664.1139582862@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[ please refrain from top-quoting, and try not to repeat the entire
previous post; we do have archives you know ]
Rick Gigger <rick(at)alpinenetworking(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-10 14:58:49 | Re: implicit cast of empty string to timestamp |
| Previous Message | Nina | 2006-02-10 13:35:32 | "psql -At -F" export column from table to .csv |