"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