Re: pg_upgrade - link mode and transaction-wraparound data loss - Mailing list pgsql-hackers

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