From: Shane Ambler <pgsql@Sheeky.Biz>
To: Márcio Aguiar Ribeiro <aguiar.marcio@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Server format and recovery
Date: Fri, 25 Apr 2008 23:33:45 +0930
Message-ID: <4811E4C1.7000803@Sheeky.Biz> (raw)
In-Reply-To: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
References: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
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
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: pgsql@Sheeky.Biz, aguiar.marcio@gmail.com
Subject: Re: Server format and recovery
In-Reply-To: <4811E4C1.7000803@Sheeky.Biz>
* 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