pg_restore listing

From: Pavel Golub <pavel(at)microolap(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: pg_restore listing
Date: 2009-09-29 09:01:57
Message-ID: 743873758.20090929120157@gf.microolap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(at)gf(dot)microolap(dot)com

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thom Brown 2009-10-10 12:52:04 Shared memory usage calculations
Previous Message Tom Lane 2009-09-14 20:03:28 Re: functions-formatting.html