Re: pg_upgrade - link mode and transaction-wraparound data loss

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