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:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 10:30 AM To: Keaton Adams Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Template zero xid issue "Keaton Adams" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
