From 3fcb7f0bd46b279da20ac3a9ffffda898c4cf573 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 21 Aug 2008 22:26:12 +0000
Subject: [PATCH] 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 fd0d56d8c0..cecc03e7e6 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>
-- 
2.50.0