Message-ID: <f5612b59b0a82bee2bf28efd314ac338bbc4c6b5.camel@cybertec.at>
Subject: Re: Fwd: Identify system databases
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Adrian Klaver <adrian.klaver@aklaver.com>, "David G. Johnston"
	 <david.g.johnston@gmail.com>
Cc: Igor Korot <ikorot01@gmail.com>, "pgsql-generallists.postgresql.org"
	 <pgsql-general@lists.postgresql.org>
Date: Wed, 16 Apr 2025 09:31:46 +0200
In-Reply-To: <bcae9b4b-a85e-4fc7-8e70-5a98c5e5ff28@aklaver.com>
References: 
	<CA+FnnTxab=JyE0DZkfL4Z2MK8RvvTud9MZiNenD45AoV_t2Mxg@mail.gmail.com>
	 <CAKFQuwYaDXuuDoEaad5sYW97pRS_FJnmfZCwY3FojnDOdfXc9Q@mail.gmail.com>
	 <CA+FnnTzwmMTNymgPuiF4CLfa6YO+HBRx4Qy5_B_KDw1oNpiukw@mail.gmail.com>
	 <CA+FnnTyWMXPEVAwNNDnCVDfmTFNHdDfffiF5vLioxyTv8Jmq0A@mail.gmail.com>
	 <817abeac-d628-4279-bfef-9e1e3aa1884b@aklaver.com>
	 <CAKFQuwbkQTbUwA4c6LFOMUWX5ojQY8DpKPQRh+xoe4VZABPWfw@mail.gmail.com>
	 <25b6cd49-f871-47fe-bf3b-5416637736ca@aklaver.com>
	 <CAKFQuwYpY7urAHuns26cw=9TKTZJU4JdVBrXWoSH_nHfZ_s3Ww@mail.gmail.com>
	 <bcae9b4b-a85e-4fc7-8e70-5a98c5e5ff28@aklaver.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/f5612b59b0a82bee2bf28efd314ac338bbc4c6b5.camel%40cybertec.at>
Precedence: bulk

On Tue, 2025-04-15 at 17:24 -0700, Adrian Klaver wrote:
> I know I can use --template=3Dtemplate with createdb, but that still mean=
s=20
> there has to be a database existing in the initial cluster to use as a=
=20
> template. You can't get around that fact.

Right.

But then you fortunately cannot drop all databases, because you cannot
drop the database you are connected to.

Still, a cluster that is missing "postgres" will give beginners trouble,
a cluster that is missing "template1" is annoying, and a cluster without
"template0" is possibly in serious trouble.

Yours,
Laurenz Albe