From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: vacuumdb maintenance-db??
Date: Wed, 9 Nov 2022 14:54:21 -0600
Message-ID: <92175f50-42f4-bb90-83cd-02b3407c0b56@gmail.com> (raw)
In-Reply-To: <CAKFQuwZyzOjF9_89t253TMhvwNSUfDrroBV_o_y3YQNRynd2BA@mail.gmail.com>
References: <36bb2141-52e0-e75a-ea4a-5f2236b76c26@gmail.com>
<CAKFQuwZyzOjF9_89t253TMhvwNSUfDrroBV_o_y3YQNRynd2BA@mail.gmail.com>
On 11/9/22 14:39, David G. Johnston wrote:
> On Wed, Nov 9, 2022 at 1:29 PM 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?
>
>
> It means that in order to query any data from a cluster you must already
> be connected to a database. Any database. Though to actually vacuum a
> database you must be connected specifically to it.
>
> I have no clue what you are getting at with your presumption and what
> specifically you are looking for documentation on. The few places that
> deal with "whole cluster" type situations, such as here, document the
> need, like you've quoted here, to connect to a database first before
> getting said cluster-level information.
I think I misread the docs, mentally adding the word "not" to "when -a/--all
is used".
But this raises a different question: when does the postgres database not exist?
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: vacuumdb maintenance-db??
In-Reply-To: <92175f50-42f4-bb90-83cd-02b3407c0b56@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox