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=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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: vacuumdb maintenance-db??
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: vacuumdb maintenance-db??