Re: 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server
Date
Msg-id 3677.1253912361@sss.pgh.pa.us
Whole thread Raw
In response to 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
Responses Re: 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server
List pgsql-hackers
"shakahshakah@gmail.com" <shakahshakah@gmail.com> writes:
> From pg_dump/pg_restore section (9.2 of the Todo page on the
> PostgreSQL Wiki), is the following item
>   "Add comments to output indicating version of pg_dump and of the
> database server"
> simply asking for a change to the pg_dump header from:

I think so, but what's not clear is whether this is a good idea to do
in the default output.  It might only be appropriate in "verbose" mode,
so as not to introduce unnecessary diffs between logically identical
dumps.  We long ago got rid of timestamps in the default output for
exactly that reason.

Another issue is that it's not all that clear what to do or how to do it
for archive dumps --- do you then want both pg_dump and pg_restore to
tell you about themselves?  If pg_restore adds anything, then this'd
also break the principle that pg_dump >foo should give identical output
to pg_dump -Fc | pg_restore >foo.  Which is something that I for one
put a great deal of stock in, for testing purposes.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: syslog_line_prefix
Next
From: Simon Riggs
Date:
Subject: Re: Hot Standby 0.2.1