Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group