Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DA7A663358B for ; Tue, 29 Sep 2009 06:07:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 25748-01 for ; Tue, 29 Sep 2009 09:07:34 +0000 (UTC) X-Greylist: delayed 00:05:04.87064 by SQLgrey-1.7.6 Received: from mail-fx0-f225.google.com (mail-fx0-f225.google.com [209.85.220.225]) by mail.postgresql.org (Postfix) with ESMTP id DD1B8632C58 for ; Tue, 29 Sep 2009 06:07:38 -0300 (ADT) Received: by fxm25 with SMTP id 25so2678144fxm.24 for ; Tue, 29 Sep 2009 02:07:36 -0700 (PDT) Received: by 10.86.243.15 with SMTP id q15mr4068371fgh.21.1254214951870; Tue, 29 Sep 2009 02:02:31 -0700 (PDT) Received: from ?192.168.1.104? (193-102-207-82.ip.ukrtel.net [82.207.102.193]) by mx.google.com with ESMTPS id e11sm1297521fga.8.2009.09.29.02.02.30 (version=SSLv3 cipher=OTHER); Tue, 29 Sep 2009 02:02:31 -0700 (PDT) Date: Tue, 29 Sep 2009 12:01:57 +0300 From: Pavel Golub X-Mailer: The Bat! (v3.62.14) Professional Reply-To: Pavel Golub Organization: Microolap X-Priority: 3 (Normal) Message-ID: <743873758.20090929120157@gf.microolap.com> To: pgsql-docs@postgresql.org Subject: pg_restore listing MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/16 X-Sequence-Number: 5271 Hello, pgsql-docs. I think it would be nice to update the listing file example (and explanation of listing) at http://www.postgresql.org/docs/8.4/static/app-pgrestore.html Now it looks like: ; ; Archive created at Fri Jul 28 22:28:36 2000 ; dbname: mydb ; TOC Entries: 74 ; Compression: 0 ; Dump Version: 1.4-0 ; Format: CUSTOM ; ; ; Selected TOC Entries: ; 2; 145344 TABLE species postgres 3; 145344 ACL species ... But modern utilities output looks a bit different: ; ; Archive created at Mon Sep 14 13:55:39 2009 ; dbname: DBDEMOS ; TOC Entries: 81 ; Compression: 9 ; Dump Version: 1.10-0 ; Format: CUSTOM ; Integer: 4 bytes ; Offset: 8 bytes ; Dumped from database version: 8.3.5 ; Dumped by pg_dump version: 8.3.8 ; ; ; Selected TOC Entries: ; 3; 2615 2200 SCHEMA - public pasha 1861; 0 0 COMMENT - SCHEMA public pasha 1862; 0 0 ACL - public pasha 317; 1247 17715 TYPE public composite pasha 319; 1247 25899 DOMAIN public domain0 pasha -- With best wishes, Pavel mailto:pavel@gf.microolap.com