Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb maintenance-db?? - Mailing list pgsql-admin

From Paul Smith
Subject Re: vacuumdb maintenance-db??
Date
Msg-id 1845e1d2840.2923.9bfe8bcc586ac955e423c0e3d5444448@pscs.co.uk
Whole thread Raw
In response to vacuumdb maintenance-db??  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
I think it's just because a connection has to be to a database, any database. Then, it'll do a "select * from pg_database" (or similar) 

I expect this option is if the "postgres" database isn't accessible for some reason 

Paul

On 9 November 2022 20:30:14 Ron <ronljohnsonjr@gmail.com> wrote:


https://www.postgresql.org/docs/13/app-vacuumdb.html


--maintenance-db=dbname

Specifies the name of the database to connect to to discover which databases should be vacuumed, when -a/--all is used. If not specified, the postgres database will be used, or if that does not exist, template1 will be used.
Presumably this means that I can create a tiny database with one table that lists a set of databases. Or maybe not.

Where is this documented?

Thanks

--
Angular momentum makes the world go 'round.


--

Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: vacuumdb maintenance-db??
Next
From: "David G. Johnston"
Date:
Subject: Re: vacuumdb maintenance-db??