recover corrupt DB?

From: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: recover corrupt DB?
Date: 2009-04-23 15:30:27
Message-ID: 82f04dc40904230830h320b4bbaq38ae3cde5f740438@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had a test system (read as not backed up, sigh) which had the disk
go full while PostgreSQL was loaded, consequently, PostgreSQL will no
longer start.

It is logging an error about detecting an invalid shutdown, trying to
replay something, and then an error about not being able to open a
file it is looking for.

Is this DB toast? Or is there something I could do to get the DB back
into a state where it will start, without losing everything?

Thanks,

Dan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rwade 2009-04-23 15:36:17 Re: Dynamic SQL in Function
Previous Message Alvaro Herrera 2009-04-23 13:29:09 Re: pg_lsclusters error after pg_dropcluster