Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists - Mailing list pgsql-general

From Matt Landry
Subject Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists
Date
Msg-id 54FA18C6.7080900@gmail.com
Whole thread Raw
In response to Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
On 03/06/2015 02:43 PM, Stephen Frost wrote:
> Right, as I mentioned, template0 shouldn't have datallowconn as 'true'.
> That's why it's being included in the pg_dumpall.
>
> On your test setup, run (as superuser):
>
> update pg_database set datallowconn = false where datname = 'template0';
>
> Then re-run the pg_upgrade.

Glory and halleleujah, it works. 9.4 now confirmed working, and all is well.

Thanks much, for your help.



pgsql-general by date:

Previous
From: dpopova@uvic.ca
Date:
Subject: How to get plpython2 in /lib?
Next
From: Tom Lane
Date:
Subject: Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists