Re: Template zero xid issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Template zero xid issue
Date
Msg-id 28944.1186419036@sss.pgh.pa.us
Whole thread Raw
In response to Re: Template zero xid issue  ("Keaton Adams" <kadams@mxlogic.com>)
List pgsql-general
"Keaton Adams" <kadams@mxlogic.com> writes:
> Sorry, I should have mentioned that to begin with: psql 8.1.4

Hmm, you know that's pretty old don't you?  The latest release in
that branch is 8.1.9 (and there'll be an 8.1.10 before long).

> It's set to false.

> mxl=3D# \c template0;
> FATAL:  database "template0" is not currently accepting connections
> Previous connection kept

That's what it should be, but nonconnectable databases are supposed to
be ignored in figuring the XID wraparound limit, so I don't see how you
got the warning mentioning template0.

Do you have autovacuum enabled?  I think there are some relevant
post-8.1.4 changes in autovac.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Template zero xid issue
Next
From: "Barry C Dowell"
Date:
Subject: Re: Move database from Solaris to Windows