Re: Help!! Crash recovery - Mailing list pgsql-general

From Bill Moran
Subject Re: Help!! Crash recovery
Date
Msg-id 20070406161123.0f030c31.wmoran@potentialtech.com
Whole thread Raw
In response to Help!! Crash recovery  (Jaime Silvela <JSilvela@Bear.com>)
List pgsql-general
In response to Jaime Silvela <JSilvela@Bear.com>:

> I know you've probably discussed this in many places, but I have a crash
> right now I need to recover from, and I'm not finding documentation that
> fast.
> Where should I go?
>
> Here are the details on starting, after a kill -9 of a process brought
> Postgres down.
>
> Is there a page/s with information on quick recovery after corruption?
> LOG:  could not create IPv6 socket: Address family not supported by protocol
> LOG:  database system was interrupted while in recovery at 2007-04-05
> 08:18:47 EDT
> HINT:  This probably means that some data is corrupted and you will have
> to use the last backup for recovery.

Do you have dumps?  Hopefully you do, in which case your best bet may be
to backup your config files, then blow away the cluster directory and
re-initdb, then restore from dump.

--
Bill Moran
http://www.potentialtech.com

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: reindexing keys in postgres
Next
From: Marcus Engene
Date:
Subject: performance; disk bad or something?