Re: Indexes getting corrupted.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bruno G(dot) Albuquerque" <balbuquerque(at)dba(dot)com(dot)br>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Indexes getting corrupted.
Date: 2005-06-10 16:57:59
Message-ID: 23641.1118422679@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Bruno G. Albuquerque" <balbuquerque(at)dba(dot)com(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2005-06-10 16:59:36 Re: select * and save into a text file failed
Previous Message Tom Lane 2005-06-10 16:55:07 Re: select * and save into a text file failed