From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Andrus <eetasoft(at)online(dot)ee> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why database is corrupted after re-booting |
Date: | 2005-10-26 16:27:04 |
Message-ID: | 1130344024.21880.3.camel@jd.commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ?
Most likely because the IDE was caching the information. IDE drives
sometimes lie about having caching turned on or off.
> How to avoid data corruption?
You could also have a bad drive.
> Will NTFS file system prevent all corruptions ?
No.
Sincerely,
Joshua D. Drake
> 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
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Troy | 2005-10-26 16:30:07 | Re: Why database is corrupted after re-booting |
Previous Message | Scott Marlowe | 2005-10-26 16:21:18 | Re: Why database is corrupted after re-booting |