pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Disk crash problems: postgres database not functioning anymore
2+ messages / 2 participants
[nested] [flat]

* Disk crash problems: postgres database not functioning anymore
@ 2006-02-21 09:21  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  0 siblings, 1 reply; 2+ messages in thread

From: Joost Kraaijeveld @ 2006-02-21 09:21 UTC (permalink / raw)
  To: pgsql-admin

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. 

Is it possible to restore that database somehow without reinstalling
PostgreSQL?

TIA


-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Disk crash problems: postgres database not functioning anymore
@ 2006-02-21 12:57  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2006-02-21 12:57 UTC (permalink / raw)
  To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-02-21 12:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-21 09:21 Disk crash problems: postgres database not functioning anymore Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2006-02-21 12:57 ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox