Re: Why database is corrupted after re-booting

Talking with various people that ran postgres at different times, one
thing they always come back with in why mysql is so much better:
postgresql corrupts too easily and you lose your data.

Personally, I've not seen corruption in postgres since 5.x or 6.x
versions from several years ago. And, I've seen corruption on mysql
(though I could not isolate between a reiserfs or mysql problem - both
with supposedly stable releases installed as part of a distro).

Is corruption a problem? I don't think so - but I want to make sure I
haven't had my head in the sand for a while. :) I realize this instance
appears to be on Windows, which is relatively new as a native Windows
program. I'm really after the answer on more mature platforms (including
Linux).

Thanks,
Greg

On Wed, 2005-10-26 at 18:27 +0300, Andrus wrote:

> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match