Re: [ADMIN] Server format and recovery

2008-04-27 Thread Márcio Aguiar Ribeiro
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 <[EMAIL PROTECTED]> wrote: > Thanks for the fast response! > > The hardware was the same of the previous, but I'm

Re: [ADMIN] Server format and recovery

2008-04-25 Thread Márcio Aguiar Ribeiro
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 differe

Re: [ADMIN] Server format and recovery

2008-04-25 Thread Tom Lane
Shane Ambler <[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 gu

Re: [ADMIN] Server format and recovery

2008-04-25 Thread Shane Ambler
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,

[ADMIN] Server format and recovery

2008-04-25 Thread Márcio Aguiar Ribeiro
Hello all, I just spent 4 days trying to recover a postgres database from a server disaster without success. A "buggy" file just erased all the HD of the server. We were able to recover almost all files, so I re-installed Ubuntu and Postgres 8.2. After that, I thought I would be able to just cop