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@xxxxxxxxxxxxx] Sent: Monday, August 06, 2007 10:30 AM To: Keaton Adams Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Template zero xid issue "Keaton Adams" <kadams@xxxxxxxxxxx> 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/
