Re: Template zero xid issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Keaton Adams <kadams(at)mxlogic(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Template zero xid issue
Date: 2007-08-06 17:02:25
Message-ID: 29132.1186419745@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lewis Cunningham 2007-08-06 17:08:27 Procedural Code Profiling
Previous Message Barry C Dowell 2007-08-06 16:57:36 Re: Move database from Solaris to Windows