Re: SEMVMX problem with postgresql

[Patrick Welche <prlw1%cam.ac.uk@localhost>]

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.

:-/