pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: vacuumdb maintenance-db??
Date: Wed, 9 Nov 2022 15:36:41 -0600
Message-ID: <fd42c22d-40d7-f4c5-0c58-fa7dceb272d4@gmail.com> (raw)
In-Reply-To: <CAKFQuwYfAHsQhieDoxVpmQH8yBCmjgGUjm1S25_BRxh8ipd_+Q@mail.gmail.com>
References: <36bb2141-52e0-e75a-ea4a-5f2236b76c26@gmail.com>
	<CAKFQuwZyzOjF9_89t253TMhvwNSUfDrroBV_o_y3YQNRynd2BA@mail.gmail.com>
	<92175f50-42f4-bb90-83cd-02b3407c0b56@gmail.com>
	<CAKFQuwYfAHsQhieDoxVpmQH8yBCmjgGUjm1S25_BRxh8ipd_+Q@mail.gmail.com>

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.

view thread (14+ messages)  latest in thread

Message-ID: <fd42c22d-40d7-f4c5-0c58-fa7dceb272d4@gmail.com>
Permalink:  ../fd42c22d-40d7-f4c5-0c58-fa7dceb272d4@gmail.com/
Also on:    postgresql.org/message-id/fd42c22d-40d7-f4c5-0c58-fa7dceb272d4@gmail.com

 · 

reply
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: <fd42c22d-40d7-f4c5-0c58-fa7dceb272d4@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