Re: Disk crash problems: postgres database not functioning anymore - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Disk crash problems: postgres database not functioning anymore
Date
Msg-id 20060221125746.GA4409@surnet.cl
Whole thread Raw
In response to Disk crash problems: postgres database not functioning anymore  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List 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.

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: Re: problems to install PostgreSQL
Next
From: "Anjan Dave"
Date:
Subject: Re: problems to install PostgreSQL