Re: Using postgresql as desktop DB

On Fri, Jun 02, 2006 at 03:50:47PM +0400, Nicholay Ryzhov wrote:
> 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.

Make sure your disk doesn't lie about fsync. Postgres can defend against
all sorts of bad hardware, but it's not magic. There are way to detect
this (check the archives).

BTW, without details about what version and what O/S and what hardware,
there really is no help anyone can give you.

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

Well, you can arrange for the system to automatically zero pages if the
header is invalid, but seriously, you evidently don't care very much
about your data.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.