| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Igor Korot <ikorot01(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fwd: Identify system databases |
| Date: | 2025-04-16 00:33:51 |
| Message-ID: | CAKFQuwZ1_WSfJOTd8kMjfCDEm_55LoLkBNJcm4GjYoc2EPTd0A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 15, 2025 at 5:24 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> >
> > By creating the initial three databases the system is more usable due to
> > having established conventions. They are conventional databases, not
> > system ones.
>
> The bottom line is the Postgres project has built an infrastructure
> around those names that the community is plugged into.
>
>
So, the answer is no, there is no dedicated pg_database column to identify
the system/conventional databases created by initdb. They are identified
by name. You must know from documentation or experience that they are
"postgres", "template1" and "template0".
Pick whichever of "system" or "convention" or some other word makes you
happy to categorize those three databases. Though I suggest "the initdb"
databases since neither of the other terms is used anywhere in the
documentation.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vijay patil | 2025-04-16 05:15:24 | Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately |
| Previous Message | Adrian Klaver | 2025-04-16 00:24:02 | Re: Fwd: Identify system databases |