Re: Indexes getting corrupted. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Indexes getting corrupted.
Date
Msg-id 23641.1118422679@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexes getting corrupted.  ("Bruno G. Albuquerque" <balbuquerque@dba.com.br>)
Responses Re: Indexes getting corrupted.  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
"Bruno G. Albuquerque" <balbuquerque@dba.com.br> writes:
> Any pointers? Is there anything I can do for Windows to actually wait
> for the postgresql processes to clean up?

What it looks like to me is that your disk drive is lying about what
it's actually written; or possibly Windows is lying to Postgres about
what it's actually written.  The former is pretty common and can usually
be fixed by turning off write caching.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: select * and save into a text file failed
Next
From: Steve Crawford
Date:
Subject: Re: select * and save into a text file failed