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

On 03/06/2015 01:55 PM, Adrian Klaver wrote:
>
> So on the original cluster, log in using psql and do \l and post the
> results here. Thanks.
[...]
> Meant to add to previous post, to check with issue that Stephen
> mentioned do:
>
> select datname, datallowconn from pg_database ;
>
>
>
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
reporting | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
(4 rows)

postgres=# select datname, datallowconn from pg_database ;
datname | datallowconn
-----------+--------------
template1 | t
template0 | t
postgres | t
reporting | t
(4 rows)

postgres=#