BUG #9620: pg_dumpall -i --globals-only = wrong behaviour

Lists: pgsql-bugs
From: postgresql(at)htmledit(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9620: pg_dumpall -i --globals-only = wrong behaviour
Date: 2014-03-18 10:31:31
Message-ID: 20140318103131.16847.54881@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9620
Logged by: Nicolas Payart
Email address: postgresql(at)htmledit(dot)com
PostgreSQL version: 9.3.3
Operating system: Linux Debian 7.4
Description:

When using short option "-i" with option "--globals-only", pg_dumpall dumps
all databases (structure and data) instead of just global objects:

pg_dumpall -i --globals-only

Using long option "--ignore-version" with "--globals-only" is ok:

pg_dumpall --ignore-version --globals-only

This problem is present on my 9.3.3 instance and is not reproducible on
older versions (9.2.7 for example).


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: postgresql(at)htmledit(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9620: pg_dumpall -i --globals-only = wrong behaviour
Date: 2014-03-18 14:07:40
Message-ID: 32162.1395151660@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

postgresql(at)htmledit(dot)com writes:
> When using short option "-i" with option "--globals-only", pg_dumpall dumps
> all databases (structure and data) instead of just global objects:
> pg_dumpall -i --globals-only

Huh. Somebody typo'd the getopt() call so that it thinks -i takes an
argument, and thus proceeds to ignore the next word on the command line.
Will fix (unfortunately, this came too late for this week's releases).
Thanks for the report!

regards, tom lane