Index: pg_dump.sgml
===================================================================
RCS file: /cvsroot/pgsql-server/doc/src/sgml/ref/pg_dump.sgml,v
retrieving revision 1.60
diff -c -c -r1.60 pg_dump.sgml
*** pg_dump.sgml 25 Mar 2003 16:15:42 -0000 1.60
--- pg_dump.sgml 17 Apr 2003 15:34:16 -0000
***************
*** 33,74 ****
! pg_dump is a utility for saving a
! PostgreSQL database into a script or an
! archive file. The script files are in plain-text format and
! contain the SQL commands required to reconstruct the database to
! the state it was in at the time it was saved. To restore these
! scripts, use . They can be used to
! reconstruct the database even on other machines and other
! architectures, with some modifications even on other SQL database
! products.
! Furthermore, there are alternative archive file formats
! that are meant to be used with to
! rebuild the database, and they also allow
! pg_restore to be selective about what is
! restored, or even to reorder the items prior to being restored. The
! archive files are also designed to be portable across
architectures.
When used with one of the archive file formats and combined with
! pg_restore, pg_dump provides a
! flexible archival and
transfer mechanism. pg_dump can be used to
! backup an entire database, then pg_restore can
! be used to examine the archive and/or select which parts of the
! database are to be restored.
! The most flexible output file format is the custom
! format (). It allows for selection and
! reordering of all archived items, and is compressed by default. The
! tar format () is not
! compressed and it is not possible to reorder data when loading, but
! it is otherwise quite flexible; moreover, it can be manipulated with
! other tools such as tar.
--- 33,79 ----
! pg_dump is a utility for backing up a
! PostgreSQL database. It makes consistent
! backups even if the database is being used concurrently.
! pg_dump does not block other users
! accessing the database (readers or writers).
! Dumps can be output in script or archive file formats. The script
! files are in plain-text format and contain the SQL commands required
! to reconstruct the database to the state it was in at the time it was
! saved. To restore these scripts, use . They
! can be used to reconstruct the database even on other machines and
! other architectures, with some modifications even on other SQL
! database products.
!
!
!
! The alternative archive file formats that are meant to be used with
! to rebuild the database, and they also
! allow pg_restore to be selective about
! what is restored, or even to reorder the items prior to being
! restored. The archive files are also designed to be portable across
architectures.
When used with one of the archive file formats and combined with
! pg_restore,
! pg_dump provides a flexible archival and
transfer mechanism. pg_dump can be used to
! backup an entire database, then pg_restore
! can be used to examine the archive and/or select which parts of the
! database are to be restored. The most flexible output file format is
! the custom format (). It allows
! for selection and reordering of all archived items, and is compressed
! by default. The tar format
! () is not compressed and it is not possible to
! reorder data when loading, but it is otherwise quite flexible;
! moreover, it can be manipulated with other tools such as
! tar.
***************
*** 77,88 ****
light of the limitations listed below.
-
- pg_dump makes consistent backups even if the
- database is being used concurrently. pg_dump
- does not block other users accessing the database (readers or
- writers).
-
--- 82,87 ----