Re: Disk crash problems: postgres database not functioning anymore

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: Pgsql-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Disk crash problems: postgres database not functioning anymore
Date: 2006-02-21 12:57:46
Message-ID: 20060221125746.GA4409@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joost Kraaijeveld wrote:
> Hi,
>
> I lost two databases due to a crash of my RAID5 which resulted in a
> filesystem corruption. One of the two databases is the "postgres"
> maintenance database of which I have no backup.

The postgres database generally doesn't have much useful info. You can
recreate it from template1 and nothing will be lost.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Anjan Dave 2006-02-21 14:50:59 Re: problems to install PostgreSQL
Previous Message Ashley Moran 2006-02-21 12:50:44 REINDEX during a transaction