On 6/20/19 1:03 PM, Espresso Beanies wrote: > I'm trying to see if someone could answer to me why the pg_dumpall > command has a database option when it's designed to dump all the > databases in a PostgreSQL server instance. I'm only asking because when > I create a .pgpass file and try to use the pg_dumpall command, I'm still > required to specify a specific database even though the command itself > should be targeting all databases. Can anyone explain this to me a bit > better? > > Thanks,
Because pg_dumpall is a client and needs to connect to a database to kick start the process/fetch global information:
Specifies the name of the database to connect to for dumping global objects and discovering what other databases should be dumped. If not specified, the postgres database will be used, and if that does not exist, template1 will be used.
