Re: Help!! Crash recovery

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: Jaime Silvela <JSilvela(at)Bear(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help!! Crash recovery
Date: 2007-04-06 20:11:23
Message-ID: 20070406161123.0f030c31.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to Jaime Silvela <JSilvela(at)Bear(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Klaas Dellschaft 2007-04-06 20:17:27 Problem with copying data
Previous Message Bill Moran 2007-04-06 20:10:06 Re: reindexing keys in postgres