Re: SEMVMX problem with postgresql

[Sarton O'Brien <bsd-xen%roguewrt.org@localhost>]

Patrick Welche wrote:
> On Tue, Mar 10, 2009 at 03:25:55PM +0000, Patrick Welche wrote:
> > On Tue, Mar 10, 2009 at 10:37:13AM +1100, Sarton O'Brien wrote:
> >
> > [Grumble: Have to look for old postgres source, as pg_resetxlog obviously
> > refuses to change 8.3 to 8.4 for the benefit of seeing the old data.]
>
> Found old 8.3.0, compiled, and
>
> quartz% pg_resetxlog -f ./data
> pg_resetxlog: pg_control exists but has invalid CRC; proceed with caution
> Transaction log reset
> quartz% postgres -D /usr/local/pgsql/data
> FATAL:  database files are incompatible with server
> DETAIL:  The database cluster was initialized with MAXALIGN 1093850759, but the 
> server was compiled with MAXALIGN 4.
> HINT:  It looks like you need to initdb.

Yeah, this was probably my main point, the old database, despite being 
generated from the same version but recompiled, was no longer accessible.

You'll notice those other error messages are gone though :)

I'm guessing/hoping you did a dump before the upgrade :S

Sarton