Re: Template zero xid issue

-----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(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
>
> ---------------------------(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-----