Re: BUG #5901: Delayed Write Failed - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #5901: Delayed Write Failed
Date
Msg-id 4D6B166C.5060006@hogranch.com
Whole thread Raw
In response to BUG #5901: Delayed Write Failed  ("Gie Rizkiadi" <gie05tech@yahoo.co.id>)
List pgsql-bugs
On 02/27/11 7:13 PM, Gie Rizkiadi wrote:
> I have installed PostgreSQL 8.4.1 running on 112 Embedded PC OS Microsoft
> Windows XP Embedded Version 2002 Service Pack 2 Intel(R) Atom(TM) CPU N270
> @1.60 GHz 1.32 GHz, 0.99 GB of RAM and 8GB Harddisk ( 6GB Free ) which are
> connected to LAN, most of that during network problems or disconnected
> causes PostgreSQL services suddenly stop and cannot start anymore even
> manually, the taskbar shows Windows Delayed Write Failed. Is anyone know
> what cause of this and how to solve this ?

you can not run a database server on unreliable network storage.  you
really shouldn't run a database server on any sort of network file
shared storage (SMB/CIFS, etc).

Delayed Write means the operating system has cached data in memory that
its unable to write to the disk, so it doesn't know what to do since it
already told the application that it was OK to continue.

pgsql-bugs by date:

Previous
From: Gie Rizkiadi
Date:
Subject: Re: Delayed Write Failed
Next
From: "Ingmar Brouns"
Date:
Subject: BUG #5902: pl/pgsql plans are not invalidated on discard all