Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 672932E0054 for ; Fri, 25 Apr 2008 11:51:32 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 69392-02 for ; Fri, 25 Apr 2008 11:51:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id F41BF2E003A for ; Fri, 25 Apr 2008 11:51:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3PEpNh0019576; Fri, 25 Apr 2008 10:51:23 -0400 (EDT) To: Shane Ambler cc: =?ISO-8859-1?Q?M=E1rcio_Aguiar_Ribeiro?= , pgsql-admin@postgresql.org Subject: Re: Server format and recovery In-reply-to: <4811E4C1.7000803@Sheeky.Biz> References: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com> <4811E4C1.7000803@Sheeky.Biz> Comments: In-reply-to Shane Ambler message dated "Fri, 25 Apr 2008 23:33:45 +0930" Date: Fri, 25 Apr 2008 10:51:22 -0400 Message-ID: <19575.1209135082@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/253 X-Sequence-Number: 29017 Shane Ambler 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