Re: Postgres crashes,help to recover

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres crashes,help to recover
Date: 2005-07-20 11:04:03
Message-ID: dblb3s$1bop$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> What version exactly was this? There was some changes in 8.0.2 in this
> area on win32. The default sync method was also changed at this point.

"PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"

> What's the output of "show wal_sync_method"?

"open_datasync"

> Finally, go into device manager, find your disk, get properties, look
> under Policies, is the box for "Enable write caching on the disk"
> checked?

It is checked.

Does Postgres require this to be unchecked ? It is difficult to force
customers to change it.

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message silvanus 2005-07-20 11:17:21 development snapshots old
Previous Message Magnus Hagander 2005-07-20 10:47:58 Re: Postgres crashes,help to recover