BUG #16645: pg_upgrade does not mark template1 as a system database

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: nakagawa(at)goodf(dot)co(dot)jp
Subject: BUG #16645: pg_upgrade does not mark template1 as a system database
Date: 2020-09-30 01:50:00
Message-ID: 16645-54478f8719888f75@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16645
Logged by: Y. NAKAGAWA
Email address: nakagawa(at)goodf(dot)co(dot)jp
PostgreSQL version: 13.0
Operating system: Windows 10 64bit
Description:

Repro steps:
1. Install postgresql-12.4-1-windows-x64.exe and
postgresql-13.0-1-windows-x64.exe.

2. Edit pg_hba.conf's on both servers to be able to connect to the servers
without password.

3. Open command prompt with administrator privilege and type:
cd %HOMEDRIVE%%HOMEPATH%
"C:\Program Files\PostgreSQL\13\bin\pg_upgrade.exe" -d "C:\Program
Files\PostgreSQL\12\data" -D "C:\Program Files\PostgreSQL\13\data" -b
"C:\Program Files\PostgreSQL\12\bin" -B "C:\Program Files\PostgreSQL\13\bin"
-U postgres

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].

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-09-30 02:21:34 Re: BUG #16644: null value for defaults in OLD variable for trigger
Previous Message David Rowley 2020-09-30 01:05:48 Re: Trigger function is not working as expected after migration from v9.6 to v11.7