Re: Postgres crashes,help to recover - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Postgres crashes,help to recover
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7795@algol.sollentuna.se
Whole thread Raw
In response to Postgres crashes,help to recover  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
> > And do your disks honour the fsync? Was a power failure the
> cause of this?
>
>
> I have usual office PC using Quantum FireballP LM20.5   20 GB
> IDE HDD with
> XP drivers.
> How to determine is fsync working or not ?
> I use default postgres.conf file ( added only listen_addresses = '*' )

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.

What's the output of "show wal_sync_method"?

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

//Magnus

pgsql-general by date:

Previous
From: Marco Colombo
Date:
Subject: Re: RAMFS with Postgres
Next
From: "Andrus"
Date:
Subject: Re: Postgres crashes,help to recover