Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cKLMC-0002mU-0g for pgsql-general@arkaria.postgresql.org; Fri, 23 Dec 2016 08:37:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cKLMB-0001zg-08 for pgsql-general@arkaria.postgresql.org; Fri, 23 Dec 2016 08:37:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cKLJk-0007hw-Rt for pgsql-general@postgresql.org; Fri, 23 Dec 2016 08:35:08 +0000 Received: from 167.1.70.195.rev.dfinet.net ([195.70.1.167] helo=33229-ml-01.dfinet.ch) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cKLJg-0001DB-1O for pgsql-general@postgresql.org; Fri, 23 Dec 2016 08:35:06 +0000 Received: from 33229-ml-01.dfinet.ch (localhost [127.0.0.1]) by 33229-ml-01.dfinet.ch (Postfix) with ESMTPS id EE8CCC413209 for ; Fri, 23 Dec 2016 09:35:01 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by 33229-ml-01.dfinet.ch (Postfix) with ESMTP id DFB9AC453098 for ; Fri, 23 Dec 2016 09:35:01 +0100 (CET) X-Virus-Scanned: amavisd-new at 33229-ml-01.dfinet.ch Received: from 33229-ml-01.dfinet.ch ([127.0.0.1]) by localhost (33229-ml-01.dfinet.ch [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id zm0oaib6fJBp for ; Fri, 23 Dec 2016 09:35:01 +0100 (CET) Received: from 33229-ml-01.dfinet.ch (33229-ml-01.dfinet.ch [10.128.30.2]) by 33229-ml-01.dfinet.ch (Postfix) with ESMTP id B4E5CC413209 for ; Fri, 23 Dec 2016 09:35:01 +0100 (CET) Date: Fri, 23 Dec 2016 09:35:01 +0100 (CET) From: Daniel Westermann To: PostgreSQL General Message-ID: <2020970042.4589542.1482482101585.JavaMail.zimbra@dbi-services.com> Subject: Is there a reason the "-v/verbose" switch is not printed with pg_dumpall --help MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4589541_688193905.1482482101585" X-Originating-IP: [178.199.179.149] X-Mailer: Zimbra 8.6.0_GA_1194 (ZimbraWebClient - FF50 (Linux)/8.6.0_GA_1194) Thread-Topic: Is there a reason the "-v/verbose" switch is not printed with pg_dumpall --help Thread-Index: Z2ovKy/gKwtqiHtD0qK3fFBxPTwlbQ== X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org ------=_Part_4589541_688193905.1482482101585 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit postgres@pgbox:/u01/app/postgres/local/dmk/ [PG961] pg_dumpall -V pg_dumpall (PostgreSQL) 9.6.1 postgres@pgbox:/u01/app/postgres/local/dmk/ [PG961] pg_dumpall --help pg_dumpall extracts a PostgreSQL database cluster into an SQL script file. Usage: pg_dumpall [OPTION]... General options: -f, --file=FILENAME output file name -V, --version output version information, then exit --lock-wait-timeout=TIMEOUT fail after waiting TIMEOUT for a table lock -?, --help show this help, then exit Options controlling the output content: -a, --data-only dump only the data, not the schema -c, --clean clean (drop) databases before recreating -g, --globals-only dump only global objects, no databases -o, --oids include OIDs in dump -O, --no-owner skip restoration of object ownership -r, --roles-only dump only roles, no databases or tablespaces -s, --schema-only dump only the schema, no data -S, --superuser=NAME superuser user name to use in the dump -t, --tablespaces-only dump only tablespaces, no databases or roles -x, --no-privileges do not dump privileges (grant/revoke) --binary-upgrade for use by upgrade utilities only --column-inserts dump data as INSERT commands with column names --disable-dollar-quoting disable dollar quoting, use SQL standard quoting --disable-triggers disable triggers during data-only restore --if-exists use IF EXISTS when dropping objects --inserts dump data as INSERT commands, rather than COPY --no-security-labels do not dump security label assignments --no-tablespaces do not dump tablespace assignments --no-unlogged-table-data do not dump unlogged table data --quote-all-identifiers quote all identifiers, even if not key words --use-set-session-authorization use SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to set ownership Connection options: -d, --dbname=CONNSTR connect using connection string -h, --host=HOSTNAME database server host or socket directory -l, --database=DBNAME alternative default database -p, --port=PORT database server port number -U, --username=NAME connect as specified database user -w, --no-password never prompt for password -W, --password force password prompt (should happen automatically) --role=ROLENAME do SET ROLE before dump If -f/--file is not used, then the SQL script will be written to the standard output. Report bugs to . It is mentioned in the documentation but not in the help output Regards Daniel ------=_Part_4589541_688193905.1482482101585 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
postgres@pgbox:/u01/app/postgres/local/dmk/ [PG961] pg_dumpall = -V
pg_du= mpall (PostgreSQL) 9.6.1
postgres@pgbox:/u01/app/postgres/local/dmk/ [PG961] pg_du= mpall --help
pg_dumpall extracts a PostgreSQL database cluster into an SQL script f= ile.

Usage:
=   pg_dumpall [OPTION]...

General options:
  -f, --file=3DFILENAME  =         output file name
  -V, --version&nb= sp;            =    output version information, then exit
  --lock-wait-timeout=3DTIM= EOUT  fail after waiting TIMEOUT for a table lock
  -?, --help  = ;            &n= bsp;    show this help, then exit

Options controlling the outpu= t content:
  -a, --data-only        &n= bsp;     dump only the data, not the schema
<= span style=3D"font-family: "courier new",courier,monaco,monospace= ,sans-serif; font-size: 10pt;" data-mce-style=3D"font-family: 'courier new'= ,courier,monaco,monospace,sans-serif; font-size: 10pt;">  -c, --clean&= nbsp;           &nbs= p;     clean (drop) databases before recreating<= br>  -g, --gl= obals-only           dump= only global objects, no databases
  -o, --oids     &= nbsp;           &nbs= p; include OIDs in dump
  -O, --no-owner      &n= bsp;        skip restoration of object o= wnership
  -r, --roles-only        &nb= sp;    dump only roles, no databases or tablespaces  -s, --sch= ema-only            = dump only the schema, no data
  -S, --superuser=3DNAME    =      superuser user name to use in the dump
<= span style=3D"font-family: "courier new",courier,monaco,monospace= ,sans-serif; font-size: 10pt;" data-mce-style=3D"font-family: 'courier new'= ,courier,monaco,monospace,sans-serif; font-size: 10pt;">  -t, --tables= paces-only       dump only tablespaces, no da= tabases or roles
  -x, --no-privileges      &n= bsp;   do not dump privileges (grant/revoke)
  --binary-upgrade = ;            for use= by upgrade utilities only
  --column-inserts     &nb= sp;       dump data as INSERT commands with c= olumn names
  --disable-dollar-quoting     disable dollar = quoting, use SQL standard quoting
  --disable-triggers    =        disable triggers during data-only rest= ore
&nbs= p; --if-exists          &= nbsp;       use IF EXISTS when dropping objec= ts
 = ; --inserts          &nbs= p;         dump data as INSERT comm= ands, rather than COPY
  --no-security-labels     &nb= sp;   do not dump security label assignments
  --no-tablespaces = ;            do not = dump tablespace assignments
  --no-unlogged-table-data    = do not dump unlogged table data
  --quote-all-identifiers   &n= bsp;  quote all identifiers, even if not key words
  --use-set-session-au= thorization
            = ;            &n= bsp;      use SET SESSION AUTHORIZATION commands i= nstead of
Connecti= on options:
  -d, --dbname=3DCONNSTR     connect using con= nection string
  -h, --host=3DHOSTNAME      database = server host or socket directory
  -l, --database=3DDBNAME    al= ternative default database
  -p, --port=3DPORT     &n= bsp;    database server port number
  -U, --username=3DNAME&nbs= p;     connect as specified database user
  -w, --no-passw= ord        never prompt for password
  -W, = --password           forc= e password prompt (should happen automatically)
  --role=3DROLENAME  = ;        do SET ROLE before dump<= br>
If -f/--fil= e is not used, then the SQL script will be written to the standardoutput.
Report bugs = to <pgsql-bugs@postgresql.org>.

It is mentioned in the documentation but not in the help output

Regard= s
Daniel
<= /div> ------=_Part_4589541_688193905.1482482101585--