diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-08-21 22:26:12 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-08-21 22:26:12 +0000 |
| commit | 3fcb7f0bd46b279da20ac3a9ffffda898c4cf573 (patch) | |
| tree | ca6e22a13208762e0c681fd05cdbc62487bd5ab6 | |
| parent | 393dc9bde237edc21591c14c6c90271397c946de (diff) | |
| download | postgresql-3fcb7f0bd46b279da20ac3a9ffffda898c4cf573.tar.gz postgresql-3fcb7f0bd46b279da20ac3a9ffffda898c4cf573.zip | |
Mention that pg_dump does not dump ALTER DATABASE ... SET commands;
backpatch to 8.3.X. Also fix markup that had just one bullet.
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 38 |
1 files changed, 16 insertions, 22 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index fd0d56d8c0e..cecc03e7e66 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.98 2007/12/11 19:57:32 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.98.2.1 2008/08/21 22:26:12 momjian Exp $ PostgreSQL documentation --> @@ -733,22 +733,13 @@ CREATE DATABASE foo WITH TEMPLATE template0; </para> <para> - <application>pg_dump</application> has a few limitations: - - <itemizedlist> - <listitem> - <para> - When a data-only dump is chosen and the option - <option>--disable-triggers</> is used, - <application>pg_dump</application> emits commands to disable - triggers on user tables before inserting the data and commands - to re-enable them after the data has been inserted. If the - restore is stopped in the middle, the system catalogs might be - left in the wrong state. - </para> - </listitem> - - </itemizedlist> + <application>pg_dump</application> has a limitation; when a + data-only dump is chosen and the option <option>--disable-triggers</> + is used, <application>pg_dump</application> emits commands + to disable triggers on user tables before inserting the data + and commands to re-enable them after the data has been + inserted. If the restore is stopped in the middle, the system + catalogs might be left in the wrong state. </para> <para> @@ -761,11 +752,14 @@ CREATE DATABASE foo WITH TEMPLATE template0; </para> <para> - The dump file produced by <application>pg_dump</application> does - not contain the statistics used by the optimizer to make query - planning decisions. Therefore, it is wise to run - <command>ANALYZE</command> after restoring from a dump file to - ensure good performance. + The dump file produced by <application>pg_dump</application> + does not contain the statistics used by the optimizer to make + query planning decisions. Therefore, it is wise to run + <command>ANALYZE</command> after restoring from a dump file + to ensure good performance. The dump file also does not + contain any <command>ALTER DATABASE ... SET</> commands; + these settings are dumped by <xref linkend="app-pg-dumpall">, + along with database users and other installation-wide settings. </para> <para> |