Re: Template zero xid issue

Sorry, I should have mentioned that to begin with: psql 8.1.4

mxl=# select datname, datallowconn from pg_database;
datname | datallowconn
--------------+--------------
postgres | t
.
.
.
template1 | t
template0 | f
(7 rows)

It's set to false.

mxl=# \c template0;
FATAL: database "template0" is not currently accepting connections
Previous connection kept

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, August 06, 2007 10:30 AM
To: Keaton Adams
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Template zero xid issue

"Keaton Adams" <kadams(at)mxlogic(dot)com> writes:
> Our production DB shut down because of it:

[ squint... ] Which PG version is this exactly? Is template0 marked as
datallowconn in pg_database, or not?

regards, tom lane