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