Using postgresql as desktop DB - Mailing list pgsql-general

From Nicholay Ryzhov
Subject Using postgresql as desktop DB
Date
Msg-id 7CC65BA698F24A4C9AABD15A3B6B6C7044890D@dc.srsc.ru
Whole thread Raw
Responses Re: Using postgresql as desktop DB  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Using postgresql as desktop DB  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
We are using postgresql in desktop database role. We cannot demand from
our users high-quality and stable hardware. So, we have frequent
problems with database in cases of unexpected power interruption or
software errors. All this problems has one kind - postgresql says
"invalid page header block relation xxx page yyy" after restarting. I
can repair such database manually by deleting random trash after real
data in currupted table. But I'm so tired to do it.

How can I to avoid this problem? Is there a tool for automatic repairing
such errors?

Nicholas
--
nicholay.ryzhov@srsc.ru



pgsql-general by date:

Previous
From: "badlydrawnbhoy"
Date:
Subject: Re: Querying for strings that match after prefix
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Using postgresql as desktop DB