On Tue, Sep 29, 2009 at 12:00 AM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > Jim Cox escribió: > >> Attached s/b a patch for the 8.5 TODO "Add comments to output indicating >> version >> of pg_dump and of the database server" (pg_dump/pg_restore section, 9.2). > > Hmm, what happens if you do a pg_dump -Fc? Is this info saved anywhere > in the dump? Surely if thi is useful in the text dump, it is useful in > the binary format dumps too.
(forgot to reply all) pg_restore's "-l, --list print summarized TOC of the archive" option does display the information in custom format dumps, e.g.: prompt$ /usr/local/pgsql/bin/pg_restore -l < /tmp/mytest.dump ; ; Archive created at Tue Sep 29 13:48:37 2009 ; dbname: mytest ; TOC Entries: 9 ; Compression: -1 ; Dump Version: 1.11-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.4.0 ; Dumped by pg_dump version: 8.4.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
