Message-ID: <4811E4C1.7000803@Sheeky.Biz>
Date: Fri, 25 Apr 2008 23:33:45 +0930
From: Shane Ambler <pgsql@Sheeky.Biz>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: =?ISO-8859-1?Q?M=E1rcio_Aguiar_Ribeiro?= <aguiar.marcio@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Server format and recovery
References: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
In-Reply-To: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Márcio Aguiar Ribeiro wrote:
> recover almost all files, so I re-installed Ubuntu and Postgres 8.2.

> pg_resetxlog . When I attempted to run the server again I received the
> following error:
> 
> "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)

Basically the server you are running now is unable to read the data 
files you have. This is to do with the way the postgresql binaries have 
been compiled.

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)

Have you reinstalled the same version of ubuntu? (and postgresql) I am 
assuming it is on the same hardware.

Did you get the same postgresql package or did you build from source?
If you built from source before you need to assign the same ./configure 
options as you did previously.


-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz