Current-Users archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

Re: SEMVMX problem with postgresql

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


Home | Main Index | Thread Index | Old Index