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

From Tom Lane
Subject Re: Template zero xid issue
Date
Msg-id 29132.1186419745@sss.pgh.pa.us
Whole thread Raw
In response to Re: Template zero xid issue  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Template zero xid issue
List pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> 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.

That should be "vacuum freeze" but otherwise this is the correct
recovery process.  However, before destroying the evidence I'd like to
find out how he got into this state ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Barry C Dowell"
Date:
Subject: Re: Move database from Solaris to Windows
Next
From: Lewis Cunningham
Date:
Subject: Procedural Code Profiling