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

Re: output file name - was pg_restore / psql

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Harald Armin Massa <ghum(at)gmx(dot)net>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: output file name - was pg_restore / psql
Date: 2004-10-04 13:49:10
Message-ID: 416154D6.3010405@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
You didn't read far enough. Just a little further down, under 22.1.3, 
you should have seen this:

    ---------------
If PostgreSQL was built on a system with the zlib compression library 
installed, the custom dump format will compress data as it writes it to 
the output file. For large databases, this will produce similar dump 
sizes to using gzip, but has the added advantage that the tables can be 
restored selectively. The following command dumps a database using the 
custom dump format:

pg_dump -Fc dbname > filename

See the pg_dump 
<http://developer.postgresql.org/docs/postgres/app-pgdump.html> and 
pg_restore 
<http://developer.postgresql.org/docs/postgres/app-pgrestore.html> 
reference pages for details.

     ------

The info i referred you to before was from the pg_restore page referred 
to here.

The correct way to submit patches is to send them to the -patches 
mailing list. Basically, for docs you would need a patch against the 
SGML source.

cheers

andrew

Harald Armin Massa wrote:

> Andrew,
>
> I know it is my fault and a "manual not read error" ... but: have you 
> skimmed lately the PostgreSQL HTML-Docs wich get installed by the 
> installer beta2-dev3?   ;)))))
>
> Within "Server Administration" there is the topic "Backup and 
> Restore"  - quite where everybody expects it.
>
> 22.1. SQL Dump says no word about formats that could get dumped...
>
> and
>
> 22.1.1.explaines:
>
> """
> The text files created by pg_dump are intended to be read in by the 
> psql program. The general command form to restore a dump is
>
> psql dbname < infile
>
> """
>
> within 22.1.3 there is also described the "official" (hey, it's the 
> official documentation!) way to compress pg_dumps
>
> pg_dump dbname | gzip > filename.gz
>
> (I took the liberty to update to "bz2" in my installations ...)
>
> ###############
>
> Is there a special place to report documentations bugs or fixes to the 
> documentation? Because I am known for reading a lot of documentation 
> stuff (still looking for man girls)   .... and if I do not stumble 
> upon this kind of information while skimming and googling; I really 
> guess there will be more in the windows world after PostgreSQL spreads 
> there who really do not find it (and I really wish it will flourish!)
>
> >regarding your other suggestions, feel free to submit a patch to 
> improve the docs. ;-)
> Could you please point me to a link how to do it best without causing 
> minimal trouble? The last "documentation patch" I suggested I 
> described in mail to Bruce Momjan ... around 3 years ago *G*
>
> Thank you very much for all your help and all the effort that you have 
> put into PostgreSQL! I am a very very happy user of this database; and 
> really was frightened that there may be some "forgotten" probs with 
> dump /restore.
>
>
> Harald
>
> ceterum censeo PSQL needs a bug tracker


In response to

pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2004-10-04 14:30:28
Subject: Re: open item: tablespace handing in pg_dump/pg_restore
Previous:From: Gavin SherryDate: 2004-10-04 13:41:50
Subject: Re: open item: tablespace handing in pg_dump/pg_restore

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