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 1u4hlB-006CKP-Ra for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 14:59:38 +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 1u4hl9-00Bd9F-75 for pgsql-general@arkaria.postgresql.org; Tue, 15 Apr 2025 14:59:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4hhr-00BWGc-Jp for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 14:56:12 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4hhp-000D6x-1o for pgsql-general@lists.postgresql.org; Tue, 15 Apr 2025 14:56:11 +0000 Received: by mail-ot1-x329.google.com with SMTP id 46e09a7af769-72bbc03d436so3499179a34.3 for ; Tue, 15 Apr 2025 07:56:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744728969; x=1745333769; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=6wUEmP1jwW2SG4mbXd+6YHF+wH/RFsevQVdhcQojNeU=; b=Sxb3XMr5Xz/hbGRl4w2T9VeDVOMVcmlbIiDJNQI+74cBjpmHCr9ZuXZ4g7ROXJJ/pD TWfOXRoB3hBK3pFVQuxSFWgtZHcEzIGrNX4uB4YYAQoA9tJ+2ESClnt8pfljg3tFmt9b x8VlV46BnX1HCs8GVhBK5flDgRDQoLZoFmg7Yq32x73P2bqFdBXqVQKj17MLtjB6Gd5d +mjfWurIsaGXI8iA+Nge7pcMCD0o9sOPXS+iAlAYG7Ns3Ha9llUE76dIb3oMZK8XPwoQ ibivc18MeKBuqBodhM8dDSu8ht9HG7vzo11p4eWwizPoOlBZZ6r66pHMRaGj1zgT6S+M 97Bg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744728969; x=1745333769; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=6wUEmP1jwW2SG4mbXd+6YHF+wH/RFsevQVdhcQojNeU=; b=bE6aSKyECRcv51BHx/RfhySVW8JhS4Qtaa3cIxZz+4UkN6P1QoiAQzFrp32UHZm226 IL3JZdWmC5N5uwZdABNJDZWwyrtnGI6eQeUF5VA0tM0Hz/NKKGLwxds/iS+s2QiWxLda HeGVLWgtbI+ki2pNVnYGakHB6j16CqGMOZcPq1d5+5oqLZ49gOZhh2Vj2yh4GJ8z+GD/ boK8pqfWm0HZNIocv3daHMcqUewz6XHQC/b8jrrzjuPe9k6ZUoUtdIcXODv0DNBrXsUt 76tB4+p7pqlUS7Aa+mXDQxRjdQDC6KmjHuJaQMjDVANvyaOkEhEcc4wJBBT4/hLpx/EN TfNQ== X-Gm-Message-State: AOJu0Yw5m3D1S43xIVvt4qHqY1QKxMchXPzd/1WXNz+MVOvhst0jwWCn 7PB6255ZiAFUrL9uc4Kju2P5Vrq5T84nSWqaDB5dV+J+JYIpEPviibNa8w2Bb0JlkcrX9jYNOuE Bjp1IGVmSh+XHV3ABids8pDLX0VE= X-Gm-Gg: ASbGncs0834iQT43fJwMovWv8J2VlLF32+lqv0IGf6Bx2nSWO1mSFIX0A9MG6+WhD3p bS2lXSvv8lv3j38EbYwr2KwhJGr7TrdqmnAKXNSTcgkp0W8cXtp6wFZj/AnX+Xm+iw3au1FBonP ApgLiiz67FRtiXg7x0+ira X-Google-Smtp-Source: AGHT+IFoqBiA1qb0hy/QLFHbu47PtiC3FaDY4ntyFdGq7ZsiEktM0KZRbc15ubCL9m9cE2NwUYvQny4+mumf+NrjEgE= X-Received: by 2002:a05:6808:189e:b0:3f6:729c:810 with SMTP id 5614622812f47-400850250abmr9192185b6e.4.1744728969082; Tue, 15 Apr 2025 07:56:09 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:7544:0:b0:589:13f9:e937 with HTTP; Tue, 15 Apr 2025 07:56:07 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 15 Apr 2025 07:56:07 -0700 X-Gm-Features: ATxdqUENg6FCB6POGbpmtqfOTj_Zw5Y3pVJitYSwJf4E9dT_8X04cZzObttHBHo Message-ID: Subject: Re: Identify system databases To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006e7d1b0632d25ead" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006e7d1b0632d25ead Content-Type: text/plain; charset="UTF-8" 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? David J. --0000000000006e7d1b0632d25ead Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, April 15, 2025, Igor Korot <ikorot01@gmail.com> wrote:
<= div dir=3D"auto">Hi, ALL,
Is there a field in the pg_datab= ases table which indicates that particular DB is a system one?
<= /blockquote>

What is a system database?

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