Skip site navigation (1) Skip section navigation (2)

Re: BUG #5986: pg_dump output is not ordered

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5986: pg_dump output is not ordered
Date: 2011-04-19 14:27:46
Message-ID: 1303223266.24799.13.camel@fsopti579.F-Secure.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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 response to

Responses

pgsql-bugs by date

Next:From: Daniel GraceDate: 2011-04-19 18:54:49
Subject: BUG #5987: Rows created by WITH (INSERT ... RETURNING) are not visible to the rest of the query
Previous:From: Kevin GrittnerDate: 2011-04-19 13:42:27
Subject: Re: BUG #5986: pg_dump output is not ordered

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group