Re: New pg_dump patch -- document statistics collector exception (REVISED PATCH) - Mailing list pgsql-hackers

From Bryce Nesbitt
Subject Re: New pg_dump patch -- document statistics collector exception (REVISED PATCH)
Date
Msg-id 497A3030.7030005@obviously.com
Whole thread Raw
In response to Re: New pg_dump patch -- document statistics collector exception  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: New pg_dump patch -- document statistics collector exception (REVISED PATCH)  (Josh Berkus <josh@agliodbs.com>)
Re: New pg_dump patch -- document statistics collector exception (REVISED PATCH)  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-hackers
Here's a revision (thanks Robert Treat for the spelling corrextion).
If there are no other objections, how do I nominate it for consideration?
                  -Bryce

Index: pg_dump.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v
retrieving revision 1.106
diff -c -2 -r1.106 pg_dump.sgml
*** pg_dump.sgml    5 Jan 2009 16:54:36 -0000    1.106
--- pg_dump.sgml    23 Jan 2009 20:57:36 -0000
***************
*** 727,733 ****
      <term><envar>PGDATABASE</envar></term>
      <term><envar>PGHOST</envar></term>
      <term><envar>PGPORT</envar></term>
-     <term><envar>PGUSER</envar></term>

      <listitem>
       <para>
--- 727,734 ----
      <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>
      <listitem>
       <para>
***************
*** 735,738 ****
--- 736,740 ----
       </para>
      </listitem>
+
     </varlistentry>
    </variablelist>
***************
*** 758,761 ****
--- 760,772 ----
     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</application> <envar>PGOPTIONS</envar> environment variable,
+    or via <literal>ALTER USER</literal>.
+   </para>
+
+
   </refsect1>

Index: pg_dumpall.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v
retrieving revision 1.74
diff -c -2 -r1.74 pg_dumpall.sgml
*** pg_dumpall.sgml    5 Jan 2009 16:54:36 -0000    1.74
--- pg_dumpall.sgml    23 Jan 2009 20:57:36 -0000
***************
*** 446,449 ****
--- 446,450 ----
     <varlistentry>
      <term><envar>PGHOST</envar></term>
+     <term><envar>PGOPTIONS</envar></term>
      <term><envar>PGPORT</envar></term>
      <term><envar>PGUSER</envar></term>
Index: pg_restore.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v
retrieving revision 1.77
diff -c -2 -r1.77 pg_restore.sgml
*** pg_restore.sgml    5 Jan 2009 16:54:36 -0000    1.77
--- pg_restore.sgml    23 Jan 2009 20:57:36 -0000
***************
*** 538,541 ****
--- 538,542 ----
     <varlistentry>
      <term><envar>PGHOST</envar></term>
+     <term><envar>PGOPTIONS</envar></term>
      <term><envar>PGPORT</envar></term>
      <term><envar>PGUSER</envar></term>

pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Next
From: Andrew Chernow
Date:
Subject: Re: AIX 4.3 getaddrinfo busted