Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists

From: Matt Landry <lelnet(dot)matt(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists
Date: 2015-03-06 21:14:46
Message-ID: 54FA18C6.7080900@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-03-06 21:20:05 Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists
Previous Message dpopova 2015-03-06 20:44:09 How to get plpython2 in /lib?