| From: | Jim Cox <shakahshakah(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Fetter <david(at)fetter(dot)org> |
| Subject: | Re: [PATCH] 8.5 TODO: Add comments to output indicating version of pg_dump and of the database server |
| Date: | 2009-09-29 13:58:08 |
| Message-ID: | c2ee6dbd0909290658k974a80axb8cbed26189f3c88@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 29, 2009 at 12:00 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stef Walter | 2009-09-29 13:59:31 | Re: pg_hba.conf: samehost and samenet [REVIEW] |
| Previous Message | Tom Lane | 2009-09-29 13:48:46 | Re: Rejecting weak passwords |