Re: BUG #16645: pg_upgrade does not mark template1 as a system database - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16645: pg_upgrade does not mark template1 as a system database
Date
Msg-id 805341.1601433939@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16645: pg_upgrade does not mark template1 as a system database  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #16645: pg_upgrade does not mark template1 as a system database  ("Y. NAKAGAWA" <nakagawa@goodf.co.jp>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> 4. Open pgAdmin 4, connect to the PostgreSQL 13.0 server and expand the
> Databases node.
> Expected result:
> The node has [postgres].
> Actual result:
> The node has [postgres] and [template1].

There's no particular concept of a "system database" in Postgres,
so I don't know what pgadmin is doing to decide which databases
to show or not show, but evidently it's not too well thought out.

(The closest concept I can think of is whether a DB is marked
datistemplate, but a test confirms that pg_upgrade successfully
preserves that property on template0 and template1.)

I'd suggest you file this complaint on the pgadmin lists.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16644: null value for defaults in OLD variable for trigger
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16636: Upper case issue in JSONB type