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

On 2010-05-18 20:52, Bruce Momjian wrote:
> This line above looks very odd because I didn't think the template0
> datfrozenxid could be advanced.  Can I see the output of this query:
>
> 	SELECT datname, datfrozenxid, datallowconn FROM pg_database;
>
>    

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)

> I am wondering if you set datallowconn for template0 to 'true'.

 From this database, I cannot give any more results, I ran some other
queries and then restarted postgres, subsequently it seemed
totally broken. I'm in the process of running the test over again, but
it'll take a while before data is in.  I'll report back.

-- 
Jesper