Re: Server format and recovery

Shane Ambler <pgsql@Sheeky.Biz> writes:
> M�rcio Aguiar Ribeiro wrote:
>> "FATAL:  database files are incompatible with server
>> The database cluster was initialized with MAXALIGN 0, but the server
>> waas compiled with MAXALIGN 4." (translated from my language to
>> english by me)

> My first guess is that the new postgresql binaries are 64 bit but the
> old install was 32 bit. (I don't actually know the conditions for the
> MAXALIGN value)

That's what I'm guessing too; see the previous report here:

http://archives.postgresql.org/pgsql-admin/2007-12/msg00254.php
http://archives.postgresql.org/pgsql-admin/2008-01/msg00023.php

The symptoms are a bit different (eg, large value instead of zero
for MAXALIGN) but that's not too surprising considering that 8.1
and 8.2 have different sets of fields in pg_control.

You'll need to get binaries that matched your originals and then
reinstall the database from your backup.

            regards, tom lane