From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomasz Szypowski <tomasz.szypowski@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_upgrade
Date: Mon, 18 Mar 2019 10:33:01 -0400
Message-ID: <2267.1552919581@sss.pgh.pa.us> (raw)
In-Reply-To: <CACmJi2JUhGo2ZxqDkh-EPHNjEN1ZA1S64uHLJFWHBhUuV4492w@mail.gmail.com>
References: <CACmJi2JUhGo2ZxqDkh-EPHNjEN1ZA1S64uHLJFWHBhUuV4492w@mail.gmail.com>
Tomasz Szypowski <tomasz.szypowski@gmail.com> writes:
> while using pg_upgrade I receive an error:
> pg_restore: dropping DATABASE template1
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 1955; 1262 1 DATABASE
> template1 postgres
> pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop a
> template database
> Command was: DROP DATABASE "template1";
Hmmm ... I could believe this would happen if you've removed the
is_template marking from template1 in the source installation.
That doesn't seem like a terribly good idea though, so I'm not
inclined to try to figure a way for pg_dump to work around it.
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, tomasz.szypowski@gmail.com
Subject: Re: pg_upgrade
In-Reply-To: <2267.1552919581@sss.pgh.pa.us>
References: <CACmJi2JUhGo2ZxqDkh-EPHNjEN1ZA1S64uHLJFWHBhUuV4492w@mail.gmail.com> <2267.1552919581@sss.pgh.pa.us>
* 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