Thread: BUG #5986: pg_dump output is not ordered
The following bug has been logged online: Bug reference: 5986 Logged by: Daniel Migowski Email address: dmigowski@ikoffice.de PostgreSQL version: 8.3.14 Operating system: Many Description: pg_dump output is not ordered Details: Hi, I would love to give pg_dump an option to produce ordered output. This would make it much easier to create dump files that are comparable with a textual diff tools. The following orderings are required: * Dump objects ordered by name. I know this cannot be done with all objects, but at least remain a reproducable, deterministic order. Also nice would be: * Dump data ordered by primary key, or if not available, dump data ordered by all columns. In addition it would be nice to have an option to omit oid comments, because oids are usually not used in databases. Thank you very much.
"Daniel Migowski" <dmigowski@ikoffice.de> wrote: > I would love to give pg_dump an option to produce ordered output. This is a feature request, not a bug -- so this list is not the right place to discuss it. A discussion like this would be more appropriate on the pgsql-general list. When starting a new thread, it might be good to browse this page to pick the most appropriate list: http://www.postgresql.org/community/lists/ This helps people focus on the discussion in which they are most interested. The volume of posts can be overwhelming otherwise. Thanks, -Kevin
On Tue, 2011-04-19 at 12:52 +0000, Daniel Migowski wrote: > I would love to give pg_dump an option to produce ordered output. This would > make it much easier to create dump files that are comparable with a textual > diff tools. > > The following orderings are required: > > * Dump objects ordered by name. I know this cannot be done with all objects, > but at least remain a reproducable, deterministic order. It does do that. > Also nice would be: > > * Dump data ordered by primary key, or if not available, dump data ordered > by all columns. Hmm, that would probably make pg_dump 5000 times slower on average. There are various tools out there that can compare data between databases that might do a better job. > In addition it would be nice to have an option to omit oid comments, because > oids are usually not used in databases. It doesn't do that anymore in recent versions.
In Agile developement cycle was very useful to be able to do a "dump with ordered data". For example were the data table was metadata and a dump of the database was upload to a SVN. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5986-pg-dump-output-is-not-ordered-tp4313186p4379180.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.