Re: postgres crash SOS

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Felde Norbert <fenor77(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: postgres crash SOS
Date: 2010-06-17 14:35:26
Message-ID: AANLkTinmZ_hDG6wXy37iP9VfiFRZNDaagHYntmJ61ZeE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 17, 2010 at 4:47 AM, Felde Norbert <fenor77(at)gmail(dot)com> wrote:
> Before I began I made a filesystem level backup after I stopped the
> postgres service.
> I have the original 0003 file, the size is 204800, The size of the
> other files in this dir is 262144.

hm...any indication of why the file is small? run out of space?
filesystem/os issues?

try appending hex 0x55 to the end of the file until it's the right
length and starting up the database. disable everything (don't vacuum)
and immediately try to pull off a dump.

what's the last good backup you have?

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-06-17 14:39:00 Re: postgres crash SOS
Previous Message Merlin Moncure 2010-06-17 14:32:01 Re: oid data types mapping in libpq functions