Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osrho-00089H-5f for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 20:29:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1osrhn-0003R6-1k for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 20:29:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osrhm-0003Qs-Jt for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 20:29:50 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1osrhk-0000Co-12 for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 20:29:50 +0000 Received: by mail-oi1-x22d.google.com with SMTP id m204so20071063oib.6 for ; Wed, 09 Nov 2022 12:29:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:from:content-language:to:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=imnFVvjhjnknW8bJBc55LeNMdv1HB4EVFu8PaBhuaCo=; b=cZ8xuX2+4+aJbCPa/hAL3iHiMmAJBmdrH1sPMh5t6mOsUNR25hRSomLdaNaIE8yOz1 M+F9b6SsDNvRjfbAd1EzW0WHFFzMIG9RlSePiLfvF6gnOUdDddvEqpQzq02HB2d3kx9a KOJcRv1Q/52RQNwAjJEvOwRqPogZVcXhcvlldMYFMr9T4hlGJkcq2HGUBPa7t9kUrVg9 B0+JhM1jFkhbelqvBXsu0CjBtWPopBVHH6bUu68Uik0ttbAyR2yToG5i0yoOf28WQXGD Vh4G0YflJn1rbIMBVqRTOz/ucNRcH8iGz4n4gYpPBO0mHKmsGG1YRphzboXZJM0+o2W0 FjbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=subject:from:content-language:to:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=imnFVvjhjnknW8bJBc55LeNMdv1HB4EVFu8PaBhuaCo=; b=RHjA9L8HAjOevpk96Lbwt70arFYmRNuAxTOHHBzDcfn2k4r9MWcmor60xGUElpYSnA T9UPBxaO/JSIgKg2HFQtOLmypWOW8Way1YPxVnyzTrFSkQoGLuBdlzQD8KWtQZ0dlekF iw0MOyJwe/viOy0N+rRXcbt5t6kl9B/vJU3hFo3HgHWIKGKxubYpLAbRlhfUvkLH6shv tMFVYKc3GWvFHF4wdEv4MVmy2vZ3i7YlAUILHcL5/6gSd7mvXtwT6lTY8JY2EA3z5NCr gWrRx8mXeQmkGikLpYAexx4kymIJQiX5mVOTQ2vUpXzMchsFmNnijp3jEw/RfHPYrf5b EdpQ== X-Gm-Message-State: ANoB5pmerS+SMF1e0lylatTeG4QihgAEbxpGVjArloNT2UvnUaBAdJq0 xq4zrNelO9IF2myNZkzTQmIenFaKPmg= X-Google-Smtp-Source: AA0mqf5WAYlnWGB2QxK1k7+Xa2fc2T9qYzEqUcvgfkL7T03xSY9u2c0e/Irf6ouRpDVaCwnNwcyZWw== X-Received: by 2002:a05:6808:2217:b0:35a:93eb:faed with SMTP id bd23-20020a056808221700b0035a93ebfaedmr6864535oib.173.1668025785678; Wed, 09 Nov 2022 12:29:45 -0800 (PST) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id j19-20020a4adf53000000b0049f08b7e8a5sm2333167oou.46.2022.11.09.12.29.45 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 09 Nov 2022 12:29:45 -0800 (PST) Content-Type: multipart/alternative; boundary="------------8dT7vqhDPOagqZJO06yEqELe" Message-ID: <36bb2141-52e0-e75a-ea4a-5f2236b76c26@gmail.com> Date: Wed, 9 Nov 2022 14:29:44 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: Ron Subject: vacuumdb maintenance-db?? List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------8dT7vqhDPOagqZJO06yEqELe Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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. --------------8dT7vqhDPOagqZJO06yEqELe Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
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.
--------------8dT7vqhDPOagqZJO06yEqELe--