From: Márcio Aguiar Ribeiro <aguiar.marcio@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Shane Ambler <pgsql@sheeky.biz>
Cc: pgsql-admin@postgresql.org
Subject: Re: Server format and recovery
Date: Sat, 26 Apr 2008 15:45:05 -0300
Message-ID: <4dd8f37f0804261145m5e1b623bwc222972a6c2c6a2c@mail.gmail.com> (raw)
In-Reply-To: <4dd8f37f0804250839y5f2f49cdu9c813c73005cf32b@mail.gmail.com>
References: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
<4811E4C1.7000803@Sheeky.Biz>
<19575.1209135082@sss.pgh.pa.us>
<4dd8f37f0804250839y5f2f49cdu9c813c73005cf32b@mail.gmail.com>
The problem was that! I reinstalled the OS using the 64bit version and
copied the postgres data dir and it worked!
Thank you!
On Fri, Apr 25, 2008 at 12:39 PM, Márcio Aguiar Ribeiro
<aguiar.marcio@gmail.com> wrote:
> Thanks for the fast response!
>
> The hardware was the same of the previous, but I'm not sure about
> Ubuntu version.
> As I got the whole old server backup, I know that the Postgres version
> is 8.2 by looking at the PGVERSION file. Not sure if it is 8.2.5, but
> I imagined that it wouldn't make much difference.
>
> I installed the postgres via apt-get, and the installation structure
> was the same of the previous one. I even tried to copy the whole
> Postgres installation from the backup, but when I try to start the
> server with the postgres command, I receive an error from the OS
> saying it was impossible to execute the binaries. Now I'm thinking
> that a 64bit version was installed.
>
> I'll try to investigate this a little further and keep up with you.
>
> Thanks for the help!
>
>
>
> On Fri, Apr 25, 2008 at 11:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > 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
> >
>
>
>
> --
> Marcio Aguiar Ribeiro
>
--
Marcio Aguiar Ribeiro
Rio de Janeiro/RJ, Brasil
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: aguiar.marcio@gmail.com, tgl@sss.pgh.pa.us, pgsql@sheeky.biz
Subject: Re: Server format and recovery
In-Reply-To: <4dd8f37f0804261145m5e1b623bwc222972a6c2c6a2c@mail.gmail.com>
* 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