This is a proposed patch to document disabling the statistics collector
pg_dump activity, and give a bit more visibility to the PGOPTIONS
environment variable supported by libpq.
It is an alternative to the prior patch, which supplied a --no-stats flag.
This is a documentation only patch, not tied to a recent code change.
? HTML.index
? test.man
Index: ref/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
*** ref/pg_dump.sgml 5 Jan 2009 16:54:36 -0000 1.106
--- ref/pg_dump.sgml 21 Jan 2009 01:15:41 -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,770 ----
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 varriable, or via <literal>ALTER
USER</literal>.
+ </para>
+
+
</refsect1>
Index: ref/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
*** ref/pg_dumpall.sgml 5 Jan 2009 16:54:36 -0000 1.74
--- ref/pg_dumpall.sgml 21 Jan 2009 01:15:41 -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: ref/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
*** ref/pg_restore.sgml 5 Jan 2009 16:54:36 -0000 1.77
--- ref/pg_restore.sgml 21 Jan 2009 01:15:41 -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>