MIME-Version: 1.0
References: <CA+FnnTxab=JyE0DZkfL4Z2MK8RvvTud9MZiNenD45AoV_t2Mxg@mail.gmail.com>
 <ef83fd38-f11d-491b-9d02-86e0f2ccc575@aklaver.com> <CA+FnnTw0vtO58xhraHYPm9g++svC1wTBAVCP1dj-+xzfptnssg@mail.gmail.com>
In-Reply-To: <CA+FnnTw0vtO58xhraHYPm9g++svC1wTBAVCP1dj-+xzfptnssg@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, 15 Apr 2025 11:21:34 -0500
Message-ID: <CA+FnnTwFpzxQmTGi8_2jrFB5z_=d8H+PJuWVpfYXqY7G74-kMA@mail.gmail.com>
Subject: Fwd: Identify system databases
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bf89d50632d390ea"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTwFpzxQmTGi8_2jrFB5z_%3Dd8H%2BPJuWVpfYXqY7G74-kMA%40mail.gmail.com>
Precedence: bulk

--000000000000bf89d50632d390ea
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

---------- Forwarded message ---------
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, Apr 15, 2025 at 11:16=E2=80=AFAM
Subject: Re: Identify system databases
To: Adrian Klaver <adrian.klaver@aklaver.com>


Hi, Adrian,

On Tue, Apr 15, 2025 at 10:07=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

> On 4/15/25 07:48, Igor Korot wrote:
> > Hi, ALL,
> > Is there a field in the pg_databases table which indicates that
> > particular DB is a system one?
>
> No there is not. As a practical matter they are no different then any
> user created database, other then template0 is created with datallowconn
>   set to false.


Understood. Will filter by name=E2=80=A6

Thank you.


>
> >
> > Or it can be determined ony by name?
> >
> > Thank you.
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--000000000000bf89d50632d390ea
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><br></div><div><br><div class=3D"gmail_quote gmail_quote_container"><d=
iv dir=3D"ltr" class=3D"gmail_attr">---------- Forwarded message ---------<=
br>From: <strong class=3D"gmail_sendername" dir=3D"auto">Igor Korot</strong=
> <span dir=3D"auto">&lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01@gma=
il.com</a>&gt;</span><br>Date: Tue, Apr 15, 2025 at 11:16=E2=80=AFAM<br>Sub=
ject: Re: Identify system databases<br>To: Adrian Klaver &lt;<a href=3D"mai=
lto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt;<br></div><=
br><br><div dir=3D"auto">Hi, Adrian,</div><div dir=3D"auto"><br><div class=
=3D"gmail_quote" dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">On Tue,=
 Apr 15, 2025 at 10:07=E2=80=AFAM Adrian Klaver &lt;<a href=3D"mailto:adria=
n.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex=
;border-left:1px #ccc solid;padding-left:1ex">On 4/15/25 07:48, Igor Korot =
wrote:<br>
&gt; Hi, ALL,<br>
&gt; Is there a field in the pg_databases table which indicates that <br>
&gt; particular DB is a system one?<br>
<br>
No there is not. As a practical matter they are no different then any <br>
user created database, other then template0 is created with datallowconn <b=
r>
=C2=A0 set to false.</blockquote><div dir=3D"auto"><br></div><div dir=3D"au=
to">Understood. Will filter by name=E2=80=A6</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">Thank you.</div></div></div><div dir=3D"auto"><div cla=
ss=3D"gmail_quote" dir=3D"auto"><div dir=3D"auto"><br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex" dir=3D"auto"><br>
<br>
&gt; <br>
&gt; Or it can be determined ony by name?<br>
&gt; <br>
&gt; Thank you.<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div></div>
</div></div>

--000000000000bf89d50632d390ea--