-----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@sss.pgh.pa.us]
> 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" <kadams@mxlogic.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
>
> ---------------------------(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-----