postgres.git / summary / log / commit / refs
commit 3fcb7f0bd46b279da20ac3a9ffffda898c4cf573
Author: Bruce Momjian <bruce@momjian.us>
Date: Thu Aug 21 22:26:12 2008 +0000
First released in: 8.4.0, 8.3.4
Mention that pg_dump does not dump ALTER DATABASE ... SET commands;
backpatch to 8.3.X. Also fix markup that had just one bullet.
doc/src/sgml/ref/pg_dump.sgml | 38 ++++++++++++++++----------------------
1 file 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>
[parent: 393dc9bde237]