pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDisk 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