pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: nakagawa@goodf.co.jp
Subject: BUG #16645: pg_upgrade does not mark template1 as a system database
Date: Wed, 30 Sep 2020 01:50:00 +0000
Message-ID: <16645-54478f8719888f75@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16645
Logged by:          Y. NAKAGAWA
Email address:      nakagawa@goodf.co.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].



view thread (5+ messages)  latest in thread

Message-ID: <16645-54478f8719888f75@postgresql.org>
Permalink:  ../16645-54478f8719888f75@postgresql.org/
Also on:    postgresql.org/message-id/16645-54478f8719888f75@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, nakagawa@goodf.co.jp
  Subject: Re: BUG #16645: pg_upgrade does not mark template1 as a system database
  In-Reply-To: <16645-54478f8719888f75@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox