Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4j3J-006SjH-5b for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 16:22:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u4j3H-00D7KX-Bv for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 16:22:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4j2Q-00D0aI-4L for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 16:21:31 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4j2N-000F57-0W for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 16:21:30 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-70565ccf3bcso35325437b3.0 for ; Tue, 15 Apr 2025 09:21:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744734086; x=1745338886; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=8IvtuJc/rCxPx/NNMsLEQisvp7Z3owdqmNwCJVHG5k4=; b=Q3AOTzAF5NvzpX3D5oJE8CHlQgt0BwhMNQ/UNcE5b1wx+LYOAW8SUs87NwTzHjg7LX wKHe0FFKzKvN9dYdxcfkpDgsLHztwo4+Co8lvvkfsk6mOpa5RMHXWteic5rPfDne1qcy XuD6gTDyCKnh9uoBFb2vHCHokXPxD/3VrlSBIW/I1S2Wqui6Z1IKRV86+blF1wgnkcJh Sy59jYFtrb4apI472XywiZzi2MM6EwIc9LfcN/pt3XS9n8fijBTfH8rFsESNjMKbrQ/i ACCFanV2tfW4kBDBgzbh7T1AnlU0OI3OcXECrgEW9MKAHk0QH7qy/9bhApll3aEQ/BGd gccQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744734086; x=1745338886; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8IvtuJc/rCxPx/NNMsLEQisvp7Z3owdqmNwCJVHG5k4=; b=FtDU3Rb1QGld3GbK3HRnzp1I2GGT/bUDvdFc89br/aiddzfnqy0rInDr5sljmAbkUF l1UTKliAntxK/gVjh88wNuYizX99iHpkrheWbhs2myBtUXFcsYa3mY35nsri1NCAFb/N tREPNgVjFZoaJVlB/H8GciJKGO0680QyvmYd179LE5NYnp/NzkNycRjNLXQe+nKhmPm9 d4OqRTsYVcqUDLZAYF7tCCGLrBZOU6lzuMQzD0vSODa2HydBALu1YJEi2jh0AFhK2PKN qD51r+8s4/4vxltPLlBaxfcZKOxkm6z2ZkHHieTeulqYyQA8GZ7zIMuFUYZM4D8Cz5Hw Py1w== X-Gm-Message-State: AOJu0YwVMM+MKPhTKjXg2V6BvBnVUM+SiDNxQVxr5AMsWHNBViuLkDAB H0F5DN8CV++1xwPYJhUxtbHfVpS/nQXr7gVYELteOzg2Z/i6K1GyyNxZ3ZmkyyaFMIVarMwKRzH VZtOKsHnbvVnmq1C+Gg2kIoF+6QdqiuUo X-Gm-Gg: ASbGnctyqH7FbSbreeLObS77aq9/PSmzM6ciyuGvL3mCmRGTL1lteA9valJm4QFDrpD wYGr72hLGwAdHoGpad9TYoZiEx2wr9VO15j2Nsnj+bTPYaiLNXA6nKb+WNMAfOADkKX/24eAhID T/BLL7t2TeVvi+7kswLMfhdsX99WN4N+ISHNH/3P6MYlNuEhUDbeQgGTVr X-Google-Smtp-Source: AGHT+IFk1XssKbunyyDPDZUwKU5MJer7GkHRdvYv+nhanYyR13oRlhD4l+87yNZzRyoMFVx19wtNQN16IwFxv9KU1k0= X-Received: by 2002:a05:690c:4b87:b0:703:c752:ce4e with SMTP id 00721157ae682-705599b9e22mr277212537b3.14.1744734085932; Tue, 15 Apr 2025 09:21:25 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Igor Korot Date: Tue, 15 Apr 2025 11:21:15 -0500 X-Gm-Features: ATxdqUF3B1QLyN4v9mAAeWH19fcX5Cq357N3uYLT9PV9_kQLDkc0mkVPgSg7bHM Message-ID: Subject: Fwd: Identify system databases To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006b6c290632d38fdd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006b6c290632d38fdd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable ---------- Forwarded message --------- From: Igor Korot Date: Tue, Apr 15, 2025 at 11:15=E2=80=AFAM Subject: Re: Identify system databases To: David G. Johnston Hi, David, On Tue, Apr 15, 2025 at 9:56=E2=80=AFAM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Tuesday, April 15, 2025, Igor Korot wrote: > >> Hi, ALL, >> Is there a field in the pg_databases table which indicates that >> particular DB is a system one? >> > > What is a system database? > I consider system database a database that is created by default when the server is run for the first time. Kind of a predefined set of databases=E2=80=A6 As an example - there is a database called Postgres. It is created when the server runs for the first time, whether I as a user like it or not. Thank you. > David J. > > --0000000000006b6c290632d38fdd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


---------- Forwarded message ---------<= br>From: Igor Korot <ikorot01@gma= il.com>
Date: Tue, Apr 15, 2025 at 11:15=E2=80=AFAM
Sub= ject: Re: Identify system databases
To: David G. Johnston <david.g.johnston@gmail.com>
<= /div>

Hi, David,

On Tue, Apr 15, 2025 at 9:56= =E2=80=AFAM David G. Johnston <david.g.johnston@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">On Tuesday, April 15, 2025, Igor Korot <ikorot01@gmail.com> wrote:
Hi, ALL,Is there a field in the pg_databases table which indicates = that particular DB is a system one?

=
What is a system database?

I consider system database a database that is created = by default when the server is run for the first time.

Kind of a predefined set of databases=E2=80= =A6

As an example - ther= e is a database called Postgres. It is created when the server runs for the= first time, whether I as a user like it or not.
Thank you.


David = J.
=C2=A0
--0000000000006b6c290632d38fdd--