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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
