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 1oss2U-0000mk-Ag for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 20:51:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oss2S-0002pZ-Pg for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 20:51:12 +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 1oss2S-0002pO-Er for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 20:51:12 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oss2Q-0000NM-DQ for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 20:51:12 +0000 Received: by mail-oi1-x233.google.com with SMTP id n186so20147162oih.7 for ; Wed, 09 Nov 2022 12:51:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=w4oPhQAUpn0kFb3rmg2CCjmIBHwCjY8260nQwz8ONd4=; b=bILIH0rKIapC/5rLQjwI01bxaEiOxJh8tcQzgD5HS4DhczHCVxhsUMdMw7fhg5Ahxd oM0+sm+T+Ei0CMdy3VrGDHstF6p4sj0Wd/6mjB4wd2IzLe23plglSK2wXS8ot9CatFw8 o0dXwNnFhY0hHV4JzVikqGwMsdZ96Yn1fuL7+L+ZHiZ7oENUiJ4YCcdVBMgsqCjr04u6 UPyP72pOS2Wr0+U8Bco3XSu08XOsQ0Wy0DdnuClUy8lHzRvBim0Rho2JucMPR3S1TmXQ iCGelrm8VuRq8CZlFB6++kdABt71B6GT/Uw9enh2l5fTEqqq8sKKm5VbmKdiYYidzqby W+kw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=w4oPhQAUpn0kFb3rmg2CCjmIBHwCjY8260nQwz8ONd4=; b=yxw7WJ8of0Tldm0lO1bjXoOi+p5jjElZdo0tUhAs0JACOhN2NZs0BCxHpx7e0bxiqm W9IuXs0EqNnKwS7z+YN+IIxs4+Io/ZM0SLHidASCtzW7AlQNkJZ0plyyC+qvp1RhaPlY 9f1CouiyxYeWkT7YvXFK7PjuheCFAWPBrdWfVo5wYmfSpeJrnj5AwurFkb2G1bqsDLIR evPewyRHY5Pp5PQiGTcnJ/l3mbepEd3G37To5qxxP6EVsjUQFrlFk621khUlawPcZQS+ iEXAHHCoiOWamSGm6kCMRiKFokLnFzGqZqX5Tj/LFoKP0+pWeRAcZQe+ikVttynFjHrY btPg== X-Gm-Message-State: ACrzQf2FnovZlABqCH3w8PqW0GK3SbsIop85u3WCyRf18YfpfcX4H4ts 955NahtQWL2Yh2N8VtTwHlnaO1rH7g0= X-Google-Smtp-Source: AMsMyM6/Ei14ersfTixVXiiRxoatY6+Vm5x8uHYmvtUoiuiRSB0NpAphwIO7XAS0I62Db/SXzvrTYA== X-Received: by 2002:a05:6808:11c5:b0:34b:75dd:2ee9 with SMTP id p5-20020a05680811c500b0034b75dd2ee9mr33504163oiv.285.1668027068648; Wed, 09 Nov 2022 12:51:08 -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 s4-20020aca4504000000b0035437f4deefsm4973741oia.26.2022.11.09.12.51.07 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 09 Nov 2022 12:51:07 -0800 (PST) Message-ID: <70060ee5-032a-2cb3-3656-80887760416b@gmail.com> Date: Wed, 9 Nov 2022 14:51:07 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: vacuumdb maintenance-db?? Content-Language: en-US To: pgsql-admin References: <36bb2141-52e0-e75a-ea4a-5f2236b76c26@gmail.com> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/9/22 14:43, Scott Ribe wrote: >> On Nov 9, 2022, at 1:39 PM, David G. Johnston wrote: >> >> Presumably this means that I can create a tiny database with one table that lists a set of databases. Or maybe not. > No need to create such a database. It just means that the connection has to be made to some database, at which point system catalogs can be read. But you connect to the database(s) you want to vacuum, right? -- Angular momentum makes the world go 'round.