Alvaro Herrera wrote:
> Excerpts from jesper's message of mar may 18 13:22:12 -0400 2010:
>
> > jk@pal:~$ psql data
> > psql (9.0beta1, server 8.4.1)
> > WARNING: psql version 9.0, server version 8.4.
> > Some psql features might not work.
> > Type "help" for help.
> >
> > data# SELECT datname, datfrozenxid FROM pg_database;
> > datname | datfrozenxid
> > -----------+--------------
> > template0 | 2073823552
> > postgres | 2023820521
> > data | 2023782337
> > jk | 2023822188
> > template1 | 2073823552
> > workqueue | 2023822188
> > (6 rows)
>
> Does the old server have pg_database.datallowconn = true for template0?
The user reported back that it did not:
Only from the "old" database:data=# SELECT datname, datfrozenxid, datallowconn FROM pg_database; datname |
datfrozenxid| datallowconn-----------+--------------+-------------- template0 | 2073823552 | f postgres |
2023820521| t data | 2023782337 | t jk | 2023822188 | t template1 | 2073823552 | t workqueue |
2023822188| t(6 rows)
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com