Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Server form...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 5 Topic 4938 of 5389
Post > Topic >>

Re: Server format and recovery

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 25, 2008 at 10:51 AM

Shane Ambler <pgsql@[EMAIL PROTECTED]
> 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 re****t 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 5 Posts in Topic:
Server format and recovery
aguiar.marcio@[EMAIL PROT  2008-04-24 22:17:22 
Re: Server format and recovery
pgsql@[EMAIL PROTECTED]   2008-04-25 23:33:45 
Re: Server format and recovery
tgl@[EMAIL PROTECTED] (T  2008-04-25 10:51:22 
Re: Server format and recovery
aguiar.marcio@[EMAIL PROT  2008-04-25 12:39:35 
Re: Server format and recovery
aguiar.marcio@[EMAIL PROT  2008-04-26 15:45:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 7 13:05:53 CDT 2008.