diff options
Diffstat (limited to 'src/bin/pg_dump/README')
| -rw-r--r-- | src/bin/pg_dump/README | 30 |
1 files changed, 5 insertions, 25 deletions
diff --git a/src/bin/pg_dump/README b/src/bin/pg_dump/README index a386ac5a01..9ed81b00aa 100644 --- a/src/bin/pg_dump/README +++ b/src/bin/pg_dump/README @@ -5,16 +5,14 @@ Notes on pg_dump 2. pg_dumpall forces all pg_dump output to be text, since it also outputs text into the same output stream. -3. The plain text output format can not be used as input into pg_restore. +3. The plain text output format cannot be used as input into pg_restore. -4. pg_dump now dumps the items in a modified OID order to try to improve relaibility of default restores. - -To dump a database into the next custom format, type: +To dump a database into the new custom format, type: pg_dump <db-name> -Fc > <backup-file> -or, in TAR format +or, to dump in TAR format pg_dump <db-name> -Ft > <backup-file> @@ -28,7 +26,7 @@ To restore, try pg_restore <backup-file> --table | less - or to list in a differnet orderL + or to list in a different order pg_restore <backup-file> -l --oid --rearrange | less @@ -59,27 +57,12 @@ or, simply: pg_restore backup.bck --use=toc.lis | psql newdbname -BLOBs -===== - -To dump blobs you must use the custom archive format (-Fc) or TAR format (-Ft), and specify the ---blobs qualifier to the pg_dump command. - -To restore blobs you must use a direct database connection (--db=db-to-restore-to). - -eg. - - pg_dump --blob -Fc db-to-backup -f backup.bck - - pg_restore backup.bck --db=db-to-restore-into - - TAR === The TAR archive that pg_dump creates currently has a blank username & group for the files, but should be otherwise valid. It also includes a 'restore.sql' script which is there for -the benefit of humans. It is never used by pg_restore. +the benefit of humans. The script is never used by pg_restore. Note: the TAR format archive can only be used as input into pg_restore if it is in TAR form. (ie. you should not extract the files then expect pg_restore to work). @@ -91,6 +74,3 @@ the BLOB files at the end. Philip Warner, 16-Jul-2000 pjw@rhyme.com.au - - - |