From e0a77f56e3e8f44b5014cb7584b33661b2e273e4 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 27 Aug 2002 03:55:17 +0000 Subject: [PATCH] Cleanup of SGML --- doc/src/sgml/ref/pg_dumpall.sgml | 126 +++++++++++++++++++++------------------ doc/src/sgml/ref/vacuumdb.sgml | 10 +++- 2 files changed, 76 insertions(+), 60 deletions(-) diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index d1482d0e98..9f46b43a82 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -1,5 +1,5 @@ @@ -67,89 +67,97 @@ PostgreSQL documentation operators should be used to redirect it into a file. - - Options - - pg_dumpall accepts the following - command line arguments: + + pg_dumpall will need to connect several times to the + PostgreSQL server, asking for the password each + time. It will probably be very convenient to have a PGPASSWORDFILE in that case. + + + + + + Options - - - -c, --clean - - + + pg_dumpall accepts the following + command line arguments: + + + + -c, --clean + + Include SQL commands to clean (drop) database objects before recreating them. (This option is fairly useless, since the output script expects to create the databases themselves; they would always be empty upon creation.) - - - - - - -g, --globals-only - - + + + + + + -g, --globals-only + + Only dump global objects (users and groups), no databases. - - - - - - -h host - - + + + + + + -h host + + Specifies the host name of the machine on which the database server is running. If host begins with a slash, it is used as the directory for the Unix domain socket. The default is taken from the PGHOST environment variable, if set, else a Unix domain socket connection is attempted. - - - - - - -p port - - + + + + + + -p port + + The port number on which the server is listening. Defaults to the PGPORT environment variable, if set, or a compiled-in default. - - - - - - -U username - - + + + + + + -U username + + Connect as the given user. - - - - - - -W - - + + + + + + -W + + Force a password prompt. This should happen automatically if the server requires password authentication. - - - - - + + + + + - + Any other command line parameters are passed to the underlying calls. This is useful to control some aspects of the output format, but some options such as , , , and dbname should be avoided. - - + diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index f29eabce1b..286e3de4c7 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -1,5 +1,5 @@ @@ -59,6 +59,14 @@ PostgreSQL documentation settings and environment variables available to psql and the libpq front-end library do apply. + + + + vacuumdb will need to connect several times to the + PostgreSQL server, asking for the password each + time. It will probably be very convenient to have a PGPASSWORDFILE in that case. + + -- 2.11.0