On Wed, Mar 11, 2009 at 11:48:07AM +1100, Sarton O'Brien wrote: >> 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. My guess, repeated from last time[sic]: time_t is being written to disk, and has changed size. This is causing fallout elsewhere, as later fields are being read at the wrong offsets, giving odd results like above. -- Dan.
Attachment:
pgpvmc9u9BNL_.pgp
Description: PGP signature