pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Márcio Aguiar Ribeiro <aguiar.marcio@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Server format and recovery
Date: Thu, 24 Apr 2008 22:17:22 -0300
Message-ID: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com> (raw)

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



view thread (5+ messages)  latest in thread

Message-ID: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>
Permalink:  ../4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com/
Also on:    postgresql.org/message-id/4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: aguiar.marcio@gmail.com
  Subject: Re: Server format and recovery
  In-Reply-To: <4dd8f37f0804241817q4ac5da57t131f8f910f40209@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox