From: Christoph Berg <christoph.berg@credativ.de>
To: Matthieu Lejeune <matthieu.lejeune@exxoss.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Pg_upgradecluster failed
Date: Thu, 19 Jan 2017 14:24:59 +0100
Message-ID: <20170119132458.3e6im2vhfypajfhd@msg.credativ.de> (raw)
In-Reply-To: <45d1244b-145d-ffce-d140-0f693ae4948f@exxoss.com>
References: <45d1244b-145d-ffce-d140-0f693ae4948f@exxoss.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Re: Matthieu Lejeune 2017-01-18 <45d1244b-145d-ffce-d140-0f693ae4948f@exxoss.com>
> But with my command I got this error :
>
> oot@bas40:/etc/postgresql/9.3/main# pg_upgradecluster -v 9.5 -m upgrade 9.3
> main
> Disabling connections to the old cluster during upgrade...
> Restarting old cluster with restricted connections...
> psql: FATAL: database "template1" is not currently accepting connections
Hi,
pg_upgradecluster relies on the template1 database being accessible
for maintenance operations during the upgrade. This is currently not
configurable, but we could certainly add an option to allow passing a
different database (e.g. "postgres") for the upgrade.
> postgres=# select * from pg_database
> ;
> datname | datdba | encoding | datcollate | datctype | datistemplate |
> datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid |
> dattablespace | datacl
> ------------+--------+----------+------------+----------+---------------+--------------+--------------+---------------+--------------+------------+---------------+-------------------------------------
> template0 | 10 | 0 | C | C | t | t
> | -1 | 12030 | 200000724 | 37376355 | 1663 |
> {=c/postgres,postgres=CTc/postgres}
Uhm, "template0" must never be connected to, you shouldn't have set
datallowconn = 't. for it.
> If I try to change from false to true I got this error :
> template0 must not allow connections, i.e. its pg_database.datallowconn must
(It seems this was even wrong before you changed it now)
Mit freundlichen Grüßen,
Christoph Berg
--
Senior Berater, Tel.: +49 2166 9901 187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
pgp fingerprint: 5C48 FE61 57F4 9179 5970 87C6 4C5A 6BAB 12D2 A7AE
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: christoph.berg@credativ.de, matthieu.lejeune@exxoss.com
Subject: Re: Pg_upgradecluster failed
In-Reply-To: <20170119132458.3e6im2vhfypajfhd@msg.credativ.de>
* 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