Re: vacuumdb maintenance-db??

[Paul Smith <paul@xxxxxxxxxx>]

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@xxxxxxxxx> 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

Sign up for news & updates