Re: vacuumdb maintenance-db??
| От | Paul Smith |
|---|---|
| Тема | Re: vacuumdb maintenance-db?? |
| Дата | |
| Msg-id | 1845e1d2840.2923.9bfe8bcc586ac955e423c0e3d5444448@pscs.co.uk обсуждение исходный текст |
| Ответ на | vacuumdb maintenance-db?? (Ron <ronljohnsonjr@gmail.com>) |
| Список | pgsql-admin |
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=dbnameSpecifies the name of the database to connect to to discover which databases should be vacuumed, when
-a/--allis used. If not specified, thepostgresdatabase will be used, or if that does not exist,template1will 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 по дате отправления: