Postgres Pro
Downloads
Home   >   mailing lists

Why database is corrupted after re-booting - Mailing list pgsql-general

From Andrus
Subject Why database is corrupted after re-booting
Date
Msg-id djo7ae$1vdm$1@news.hub.org
Whole thread Raw
Responses Re: Why database is corrupted after re-booting  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Why database is corrupted after re-booting  (Gregory Youngblood <pgcluster@netio.org>)
Re: Why database is corrupted after re-booting  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Why database is corrupted after re-booting  (David Garamond <lists@zara.6.isreserved.com>)
Re: Why database is corrupted after re-booting  ("w_tom" <w_tom1@usa.net>)
List pgsql-general
Tree view 
Yesterday  computer running Postgres re-boots suddenly. After that,

select * from firma1.klient

returns

ERROR:  invalid page header in block 739 of relation "klient"

I have Quantum Fireball IDE drive, write caching is turned OFF.
I have Windows XP with FAT32  file system.
I'm using PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)

Why the corruption occurs ?  How to avoid data corruption?
Will NTFS file system prevent all corruptions ? If yes, how to convert FAT32
to NTFS without losing data in drive ?

Andrus.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Need help with INOUT mis-understanding
Next
From: "Andrus"
Date:
Subject: Re: Why database is corrupted after re-booting