| Lists: | pgsql-bugs |
|---|
| From: | "Daniel Migowski" <dmigowski(at)ikoffice(dot)de> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5986: pg_dump output is not ordered |
| Date: | 2011-04-19 12:52:40 |
| Message-ID: | 201104191252.p3JCqe2W074774@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5986
Logged by: Daniel Migowski
Email address: dmigowski(at)ikoffice(dot)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.
| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Daniel Migowski" <dmigowski(at)ikoffice(dot)de>, <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #5986: pg_dump output is not ordered |
| Date: | 2011-04-19 13:42:27 |
| Message-ID: | 4DAD4AF3020000250003C9D7@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Daniel Migowski" <dmigowski(at)ikoffice(dot)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
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From: | tute <tute(at)dc(dot)uba(dot)ar> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5986: pg_dump output is not ordered |
| Date: | 2011-05-07 23:11:03 |
| Message-ID: | 1304809863378-4379180.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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.