Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd54ae17

Browse files
committed
Document disabling the statistics collector pg_dump activity, and give a
bit more visibility to the PGOPTIONS environment variable supported bylibpq.Bryce Nesbitt
1 parent65b731b commitd54ae17

File tree

3 files changed

+15
-4
lines changed

3 files changed

+15
-4
lines changed

‎doc/src/sgml/ref/pg_dump.sgml

Lines changed: 11 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.106 2009/01/05 16:54:36 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.107 2009/02/07 14:31:30 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -726,14 +726,16 @@ PostgreSQL documentation
726726
<varlistentry>
727727
<term><envar>PGDATABASE</envar></term>
728728
<term><envar>PGHOST</envar></term>
729+
<term><envar>PGOPTIONS</envar></term>
729730
<term><envar>PGPORT</envar></term>
730-
<term><envar>PGUSER</envar></term>
731731

732+
<term><envar>PGUSER</envar></term>
732733
<listitem>
733734
<para>
734735
Default connection parameters.
735736
</para>
736737
</listitem>
738+
737739
</varlistentry>
738740
</variablelist>
739741

@@ -757,6 +759,13 @@ PostgreSQL documentation
757759
variables used by the <application>libpq</application> front-end
758760
library will apply.
759761
</para>
762+
<para>
763+
The database activity of <application>pg_dump</application> is normally collected by the statistics collector.
764+
If this is undesirable, you can set parameters <literal>stats_block_level</literal> and <literal>stats_row_level</literal> to false
765+
via the <application>libpq</> <envar>PGOPTIONS</envar> environment variable, or via <literal>ALTER USER</literal>.
766+
</para>
767+
768+
760769
</refsect1>
761770

762771

‎doc/src/sgml/ref/pg_dumpall.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.74 2009/01/05 16:54:36 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.75 2009/02/07 14:31:30 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -445,6 +445,7 @@ PostgreSQL documentation
445445
<variablelist>
446446
<varlistentry>
447447
<term><envar>PGHOST</envar></term>
448+
<term><envar>PGOPTIONS</envar></term>
448449
<term><envar>PGPORT</envar></term>
449450
<term><envar>PGUSER</envar></term>
450451

‎doc/src/sgml/ref/pg_restore.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.78 2009/02/02 20:07:36 adunstan Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.79 2009/02/07 14:31:30 momjian Exp $ -->
22

33
<refentry id="APP-PGRESTORE">
44
<refmeta>
@@ -559,6 +559,7 @@
559559
<variablelist>
560560
<varlistentry>
561561
<term><envar>PGHOST</envar></term>
562+
<term><envar>PGOPTIONS</envar></term>
562563
<term><envar>PGPORT</envar></term>
563564
<term><envar>PGUSER</envar></term>
564565

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp