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

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.