Skip site navigation (1) Skip section navigation (2)

Re: BUG #5901: Delayed Write Failed

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5901: Delayed Write Failed
Date: 2011-02-28 03:28:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-bugs by date

Next:From: Ingmar BrounsDate: 2011-02-28 14:09:57
Subject: BUG #5902: pl/pgsql plans are not invalidated on discard all
Previous:From: Gie RizkiadiDate: 2011-02-28 03:15:26
Subject: Re: Delayed Write Failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group