-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Keaton Adams wrote: > Sorry, I should have mentioned that to begin with: psql 8.1.4 1. Upgrade to the actual stable release, which is 8.1.9 2. IIRC there is a bug in 8.1.4 that causes template0 to increment when it shouldn't. Update the template0 to allow connections, vacuum full, dissallow connections, and then upgrade. Sincerely, Joshua D. Drake > > > 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/ > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGt1HXATb/zqfZUUQRAuOHAJ9jSKZXU9CzLWcgy2DYSRXLMTsqTQCgnw4V jVsSNPjay0w6MHxGWsdu8no= =oJhU -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
