Thread: Request clarification w/ PG_DUMPALL -d.
I'm trying to migrate a 9.5 DB to a current version using PG_DUMPALL.
It reclaims that what I pass in the -d parameter is missing a "=" and the man directs me to look at chapter 31.1.1 Connection Strings of the dox PDF.
The Problem is that there are different connection strings listed there and I don't know which one I should use.
Would be happy if somebody could clarify exactly what value/s I need to use for the -d parameter of PG_DUMPALL.
On 8/30/20 7:31 AM, ERR ORR wrote: > I'm trying to migrate a 9.5 DB to a current version using PG_DUMPALL. > It reclaims that what I pass in the -d parameter is missing a "=" and > the man directs me to look at chapter 31.1.1 Connection Strings of the > dox PDF. > The Problem is that there are different connection strings listed there > and I don't know which one I should use. > Would be happy if somebody could clarify exactly what value/s I need to > use for the -d parameter of PG_DUMPALL. Don't use it per the docs: https://www.postgresql.org/docs/12/app-pg-dumpall.html "The option is called --dbname for consistency with other client applications, but because pg_dumpall needs to connect to many databases, the database name in the connection string will be ignored. Use the -l option to specify the name of the database used for the initial connection, which will dump global objects and discover what other databases should be dumped." Either use -l or nothing and pg_dump will connect to postgres database. -- Adrian Klaver adrian.klaver@aklaver.com