Server format and recovery
От | Márcio Aguiar Ribeiro |
---|---|
Тема | Server format and recovery |
Дата | |
Msg-id | 4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Server format and recovery
|
Список | pgsql-admin |
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 copy my PGDATA folder from the recovered files to the server and then run the postgres server, but my pg_control file was not valid. So I executed 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) Since this, I already tried several ways to recover the data. I started a new DB with initdb and copied the base/ and global/ data to the PGDATA, but there's no use. I'm able to psql my database, but when try a "select * from pg_tables" i receive: "ERROR: unexpected chunk size 1986 in chunk 0 for toast value 10319" In other attempts I also received: "array size exceeds the maximum allowed" I out of ideas right now, so I'm asking your help. Any suggestions? Thanks! -- Marcio Aguiar Ribeiro
В списке pgsql-admin по дате отправления: