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 1osske-00033F-TY for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 21:36: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 1osskc-00063e-Oq for pgsql-admin@arkaria.postgresql.org; Wed, 09 Nov 2022 21:36:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osskc-00063C-Bd for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 21:36:50 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1osskV-00035r-Pf for pgsql-admin@lists.postgresql.org; Wed, 09 Nov 2022 21:36:49 +0000 Received: by mail-oi1-x230.google.com with SMTP id n83so20248307oif.11 for ; Wed, 09 Nov 2022 13:36:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=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=ZWo9bayJ/CUbhuvns5GSiPe0u2MoHjA9pduF2NC/7GU=; b=NsriLROJxI3qt4gL8AVr8Eat7SS2a4RROQ0KV/14/z+pB1p7LCr5hMSd6k1LSodyrj RjCmjTepOfqcWdjzlyX2mJZVWhes0BS85LyQG2oZgI/ckl9LxjRDE3PfV0w+DaIw0pii fDUDdOIJnAN1gLfrW8yFP7qaglWuKbrdRdjPvoqamOcM5tYYZsLvLnXb4jakkbIV6cc2 ukRXWdatuKujGZVa5XgxuLBiBJT291I5y3QZzJEOR/Ml1mPNzFOcO0aQg3kK/PCKrehZ WKGJyy3PrjjcS1GzcDhucb61ybEmuqVbAYCiV8SOjAaAR/BPQfRzOLIqLonl19rd0nNl t53Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=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=ZWo9bayJ/CUbhuvns5GSiPe0u2MoHjA9pduF2NC/7GU=; b=YI9drsI1rHNpfCd6moAMQKj5MohXECczzQhf+0kRm/fGQIFIkRhjG68NpErdhO6p0L pdLuwRlDgIsjPPUh2bGeCbge5ohfoNbmxB+svCG2U5Ui3q1l+c4tQK0PQkkg1kA/1cPT OwlyNrcPQIQ2OcDUSTFhKV5n3PCUI96OtRVs8XPKX9bFcQzvIG2oVP/qhK2qSP1XBEmT md3iie9CIwbdIWe2oF1l0k74GeIRLUVw6eom19FLmiz+Lrb99cvprjG4ZMPwYTpNHJuF yKzQaxbIv3JE825mS48WqVyP3UgADJ/GIoqaHAkZagAp2b/oP1FRIj198FW/hGVTuHQ/ BdXA== X-Gm-Message-State: ACrzQf32YMUycQjjq82CKa2v8pMMVtIJQ77nUcdSXMLybAibiqDd1Zhp PrA6cJfbDD+tJtSumukA2BBihoIoHyg= X-Google-Smtp-Source: AMsMyM5Vku+URG4nKXaepyUDJ7AZMyFOEI3GhoaIuKuXREVj5dyVrOX451VkROgPtRJkDHpm93HepA== X-Received: by 2002:a05:6808:219c:b0:35a:5852:64cc with SMTP id be28-20020a056808219c00b0035a585264ccmr17722882oib.114.1668029802788; Wed, 09 Nov 2022 13:36:42 -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 i9-20020a056808054900b00350743ac8eesm4987617oig.41.2022.11.09.13.36.42 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 09 Nov 2022 13:36:42 -0800 (PST) Content-Type: multipart/alternative; boundary="------------8FEukzKocQrTpc90lRTGH8sE" Message-ID: Date: Wed, 9 Nov 2022 15:36:41 -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@lists.postgresql.org References: <36bb2141-52e0-e75a-ea4a-5f2236b76c26@gmail.com> <92175f50-42f4-bb90-83cd-02b3407c0b56@gmail.com> From: Ron In-Reply-To: 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. --------------8FEukzKocQrTpc90lRTGH8sE Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 11/9/22 15:17, David G. Johnston wrote: > On Wed, Nov 9, 2022 at 1:54 PM Ron wrote: > > > But this raises a different question: when does the postgres database > not exist? > > > You are giving it too much specialness.  Both ALTER DATABASE ... RENAME > and DROP DATABASE can be used on it. Ah.  It would have never occurred to me to do that (though I'm sure there are things I do which others scratch their heads over). -- Angular momentum makes the world go 'round. --------------8FEukzKocQrTpc90lRTGH8sE Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 11/9/22 15:17, David G. Johnston wrote:
On Wed, Nov 9, 2022 at 1:54 PM Ron <ronljohnsonjr@gmail.com> wrote:

But this raises a different question: when does the postgres database not exist?


You are giving it too much specialness.  Both ALTER DATABASE ... RENAME and DROP DATABASE can be used on it.

Ah.  It would have never occurred to me to do that (though I'm sure there are things I do which others scratch their heads over).

--
Angular momentum makes the world go 'round.
--------------8FEukzKocQrTpc90lRTGH8sE--