|
1 | 1 | <!--
|
2 |
| -$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.30 2002/08/20 02:20:48 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.31 2002/08/27 03:55:17 momjian Exp $ |
3 | 3 | PostgreSQL documentation
|
4 | 4 | -->
|
5 | 5 |
|
@@ -67,89 +67,97 @@ PostgreSQL documentation
|
67 | 67 | operators should be used to redirect it into a file.
|
68 | 68 | </para>
|
69 | 69 |
|
70 |
| - <refsect2> |
71 |
| - <title>Options</title> |
72 | 70 |
|
73 |
| - <para> |
74 |
| - <application>pg_dumpall</application> accepts the following |
75 |
| - command line arguments: |
| 71 | + <para> |
| 72 | + <application>pg_dumpall</application> will need to connect several times to the |
| 73 | + <productname>PostgreSQL</productname> server, asking for the password each |
| 74 | + time. It will probably be very convenient to have a PGPASSWORDFILE in that case. |
| 75 | + </para> |
| 76 | + |
| 77 | + </refsect1> |
| 78 | + |
| 79 | + <refsect1> |
| 80 | + <title>Options</title> |
76 | 81 |
|
77 |
| - <variablelist> |
78 |
| - <varlistentry> |
79 |
| - <term>-c, --clean</term> |
80 |
| - <listitem> |
81 |
| - <para> |
| 82 | + <para> |
| 83 | + <application>pg_dumpall</application> accepts the following |
| 84 | + command line arguments: |
| 85 | + |
| 86 | + <variablelist> |
| 87 | + <varlistentry> |
| 88 | + <term>-c, --clean</term> |
| 89 | + <listitem> |
| 90 | + <para> |
82 | 91 | Include SQL commands to clean (drop) database objects before
|
83 | 92 | recreating them. (This option is fairly useless, since the
|
84 | 93 | output script expects to create the databases themselves;
|
85 | 94 | they would always be empty upon creation.)
|
86 |
| - </para> |
87 |
| - </listitem> |
88 |
| - </varlistentry> |
89 |
| - |
90 |
| - <varlistentry> |
91 |
| - <term>-g, --globals-only</term> |
92 |
| - <listitem> |
93 |
| - <para> |
| 95 | + </para> |
| 96 | + </listitem> |
| 97 | + </varlistentry> |
| 98 | + |
| 99 | + <varlistentry> |
| 100 | + <term>-g, --globals-only</term> |
| 101 | + <listitem> |
| 102 | + <para> |
94 | 103 | Only dump global objects (users and groups), no databases.
|
95 |
| - </para> |
96 |
| - </listitem> |
97 |
| - </varlistentry> |
98 |
| - |
99 |
| - <varlistentry> |
100 |
| - <term>-h <replaceable>host</replaceable></term> |
101 |
| - <listitem> |
102 |
| - <para> |
| 104 | + </para> |
| 105 | + </listitem> |
| 106 | + </varlistentry> |
| 107 | + |
| 108 | + <varlistentry> |
| 109 | + <term>-h <replaceable>host</replaceable></term> |
| 110 | + <listitem> |
| 111 | + <para> |
103 | 112 | Specifies the host name of the machine on which the database
|
104 | 113 | server is running. If host begins with a slash, it is used as
|
105 | 114 | the directory for the Unix domain socket. The default is
|
106 | 115 | taken from the <envar>PGHOST</envar> environment variable, if
|
107 | 116 | set, else a Unix domain socket connection is attempted.
|
108 |
| - </para> |
109 |
| - </listitem> |
110 |
| - </varlistentry> |
111 |
| - |
112 |
| - <varlistentry> |
113 |
| - <term>-p <replaceable>port</replaceable></term> |
114 |
| - <listitem> |
115 |
| - <para> |
| 117 | + </para> |
| 118 | + </listitem> |
| 119 | + </varlistentry> |
| 120 | + |
| 121 | + <varlistentry> |
| 122 | + <term>-p <replaceable>port</replaceable></term> |
| 123 | + <listitem> |
| 124 | + <para> |
116 | 125 | The port number on which the server is listening. Defaults to
|
117 | 126 | the <envar>PGPORT</envar> environment variable, if set, or a
|
118 | 127 | compiled-in default.
|
119 |
| - </para> |
120 |
| - </listitem> |
121 |
| - </varlistentry> |
122 |
| - |
123 |
| - <varlistentry> |
124 |
| - <term>-U <replaceable>username</replaceable></term> |
125 |
| - <listitem> |
126 |
| - <para> |
| 128 | + </para> |
| 129 | + </listitem> |
| 130 | + </varlistentry> |
| 131 | + |
| 132 | + <varlistentry> |
| 133 | + <term>-U <replaceable>username</replaceable></term> |
| 134 | + <listitem> |
| 135 | + <para> |
127 | 136 | Connect as the given user.
|
128 |
| - </para> |
129 |
| - </listitem> |
130 |
| - </varlistentry> |
131 |
| - |
132 |
| - <varlistentry> |
133 |
| - <term>-W</term> |
134 |
| - <listitem> |
135 |
| - <para> |
| 137 | + </para> |
| 138 | + </listitem> |
| 139 | + </varlistentry> |
| 140 | + |
| 141 | + <varlistentry> |
| 142 | + <term>-W</term> |
| 143 | + <listitem> |
| 144 | + <para> |
136 | 145 | Force a password prompt. This should happen automatically if
|
137 | 146 | the server requires password authentication.
|
138 |
| - </para> |
139 |
| - </listitem> |
140 |
| - </varlistentry> |
141 |
| - </variablelist> |
142 |
| - </para> |
| 147 | + </para> |
| 148 | + </listitem> |
| 149 | + </varlistentry> |
| 150 | + </variablelist> |
| 151 | + </para> |
143 | 152 |
|
144 |
| - <para> |
| 153 | + <para> |
145 | 154 | Any other command line parameters are passed to the underlying
|
146 | 155 | <xref linkend="app-pgdump">
|
147 | 156 | calls. This is useful to control some aspects of the output
|
148 | 157 | format, but some options such as <option>-f</option>,
|
149 | 158 | <option>-F</option>, <option>-t</option>, and <replaceable
|
150 | 159 | class="parameter">dbname</replaceable> should be avoided.
|
151 |
| - </para> |
152 |
| - </refsect2> |
| 160 | + </para> |
153 | 161 | </refsect1>
|
154 | 162 |
|
155 | 163 |
|
|
0 commit comments