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

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=#