Re: Using postgresql as desktop DB - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: Using postgresql as desktop DB
Date
Msg-id 7be3f35d0606030917hc330c3bkf331cc287cbcb0a3@mail.gmail.com
Whole thread Raw
In response to Using postgresql as desktop DB  ("Nicholay Ryzhov" <Nicholay.Ryzhov@srsc.ru>)
List pgsql-general
Nicholas,

in a transition period I did use PostgreSQL Win 32 8.0 and above on
high quality server hardware.

Which did not help, because of subtil problems with Windows, VMware
and some HP Server tools. Result: we had around 3 blue screens of
death every week. Sometimes even more. On a database server.
Immediate solution was allways to just restart the server, and the
database came up without crying. (long term solution to just dump that
server)


Just make sure that every write is really written to the disk, and not
to some caching facility. Triple check your fsync setting in
postgresql.conf.

Best wishes,

Harald



--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
did you ever dream of visiting CERN? The place where the antimatter
for exploding Vatican is created? To eat in cantinas
with the worlds highest propability to stand in queue with future or
past Nobel Prize Winners? To talk about Web 2.5 at the place where Web
0.1 up to Web 1.0 were developed? register at www.europython.org!

pgsql-general by date:

Previous
From: "Yavuz Kavus"
Date:
Subject: Performance difference between char and int2 columns
Next
From: Bruce Momjian
Date:
Subject: Re: Best high availability solution ?