Modify pg_dump so that the preferred dump order is by name within
Tom Lane <tgl@sss.pgh.pa.us>
Modify pg_dump so that the preferred dump order is by name within object types, rather than by OID. This should help ensure consistent dump output from databases that are logically the same but have different histories, per recent discussion about 'diffing' databases. The patch is bulky because of renaming of fields, but not very complicated. Also, do some tweaking to cause BLOB restoration to be done in a better order, and clean up pg_restore's textual output to exactly match pg_dump.
Files
| Path | Change | +/− |
|---|---|---|
| src/bin/pg_dump/common.c | modified | +7 −5 |
| src/bin/pg_dump/pg_backup_archiver.c | modified | +56 −33 |
| src/bin/pg_dump/pg_backup_custom.c | modified | +6 −7 |
| src/bin/pg_dump/pg_backup_db.c | modified | +18 −11 |
| src/bin/pg_dump/pg_backup_db.h | modified | +2 −1 |
| src/bin/pg_dump/pg_backup_files.c | modified | +3 −2 |
| src/bin/pg_dump/pg_backup_tar.c | modified | +2 −2 |
| src/bin/pg_dump/pg_dump.c | modified | +354 −291 |
| src/bin/pg_dump/pg_dump.h | modified | +13 −23 |
| src/bin/pg_dump/pg_dump_sort.c | modified | +128 −51 |