From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shane Ambler <pgsql@Sheeky.Biz>
Cc: Márcio Aguiar Ribeiro <aguiar.marcio@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Server format and recovery
Date: Fri, 25 Apr 2008 10:51:22 -0400
Message-ID: <19575.1209135082@sss.pgh.pa.us> (raw)
In-Reply-To: <4811E4C1.7000803@Sheeky.Biz>
References: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
<4811E4C1.7000803@Sheeky.Biz>
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.phphttp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql@Sheeky.Biz, aguiar.marcio@gmail.com
Subject: Re: Server format and recovery
In-Reply-To: <19575.1209135082@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox