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 ----