From: | adrian(dot)klaver(at)aklaver(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14636: pg_dumpall -d |
Date: | 2017-04-30 22:08:41 |
Message-ID: | 20170430220841.24360.15247@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14636
Logged by: Adrian Klaver
Email address: adrian(dot)klaver(at)aklaver(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: Linux openSUSE Leap 42.2
Description:
Pulled the nightly build of Postgres 10:
2017-04-30 20:30:26
Testing dump/restore from a 9.6 instance to the 10 instance. Tried dumping
the globals using pg_dumpall and connected using:
aklaver(at)tito:~> /usr/local/pgsql10/bin/pg_dumpall -g -d postgres -U postgres
-p 5432 -f production_globals.sql
pg_dumpall: missing "=" after "postgres" in connection info string
This not what I usually do and when I used -l it worked as expected. The bug
is that the docs say:
https://www.postgresql.org/docs/devel/static/app-pg-dumpall.html
"-d connstr
--dbname=connstr
Specifies parameters used to connect to the server, as a connection
string. See Section 33.1.1 for more information.
The option is called --dbname for consistency with other client
applications, but because pg_dumpall needs to connect to many databases,
database name in the connection string will be ignored. Use -l option to
specify the name of the database used to dump global objects and to discover
what other databases should be dumped.
"
Instead an error is raised.
From | Date | Subject | |
---|---|---|---|
Next Message | tomasz.kontusz | 2017-05-01 00:06:09 | BUG #14637: Tests fail with pl_PL.UTF-8 locale |
Previous Message | Michael Paquier | 2017-04-30 12:30:08 | Re: Concurrent ALTER SEQUENCE RESTART Regression |