From 7d95e6e00cdc417a5c6dd5a37bdf640c8b0aab76 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Sat, 7 Feb 2009 14:31:30 +0000
Subject: [PATCH] Document disabling the statistics collector pg_dump activity,
 and give a bit more visibility to the PGOPTIONS environment variable
 supported by libpq.

Bryce Nesbitt
---
 doc/src/sgml/ref/pg_dump.sgml    | 11 ++++++++++-
 doc/src/sgml/ref/pg_dumpall.sgml |  1 +
 doc/src/sgml/ref/pg_restore.sgml |  1 +
 3 files changed, 12 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
index 9c8563018f..7714cf271b 100644
--- a/doc/src/sgml/ref/pg_dump.sgml
+++ b/doc/src/sgml/ref/pg_dump.sgml
@@ -726,14 +726,16 @@ PostgreSQL documentation
    <varlistentry>
     <term><envar>PGDATABASE</envar></term>
     <term><envar>PGHOST</envar></term>
+    <term><envar>PGOPTIONS</envar></term>
     <term><envar>PGPORT</envar></term>
-    <term><envar>PGUSER</envar></term>
 
+    <term><envar>PGUSER</envar></term>
     <listitem>
      <para>
       Default connection parameters.
      </para>
     </listitem>
+
    </varlistentry>
   </variablelist>
 
@@ -757,6 +759,13 @@ PostgreSQL documentation
    variables used by the <application>libpq</application> front-end
    library will apply.
   </para>
+  <para>
+   The database activity of <application>pg_dump</application> is normally collected by the statistics collector.
+   If this is undesirable, you can set parameters <literal>stats_block_level</literal> and <literal>stats_row_level</literal> to false
+   via the <application>libpq</> <envar>PGOPTIONS</envar> environment variable, or via <literal>ALTER USER</literal>.
+  </para>
+
+
  </refsect1>
 
 
diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml
index 818c79efb3..ea7a541bc8 100644
--- a/doc/src/sgml/ref/pg_dumpall.sgml
+++ b/doc/src/sgml/ref/pg_dumpall.sgml
@@ -445,6 +445,7 @@ PostgreSQL documentation
   <variablelist>
    <varlistentry>
     <term><envar>PGHOST</envar></term>
+    <term><envar>PGOPTIONS</envar></term>
     <term><envar>PGPORT</envar></term>
     <term><envar>PGUSER</envar></term>
 
diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml
index 4fc17fcaad..90c70a415f 100644
--- a/doc/src/sgml/ref/pg_restore.sgml
+++ b/doc/src/sgml/ref/pg_restore.sgml
@@ -559,6 +559,7 @@
   <variablelist>
    <varlistentry>
     <term><envar>PGHOST</envar></term>
+    <term><envar>PGOPTIONS</envar></term>
     <term><envar>PGPORT</envar></term>
     <term><envar>PGUSER</envar></term>
 
-- 
2.39.5