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

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

Reply via email to