Re: vacuumdb maintenance-db??

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(at)gmail(dot)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

Sign up for news & updates at http://www.pscs.co.uk/go/subscribe