View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 04:15 AM
Tom Lane
 
Posts: n/a
Default Re: Index corruption

Marc Munro <marc@bloodnok.com> writes:
> We have now experienced index corruption on two separate but identical
> slony clusters. In each case the slony subscriber failed after
> attempting to insert a duplicate record. In each case reindexing the
> sl_log_1 table on the provider fixed the problem.


Please be more specific about what you mean by "index corruption"
.... what were the exact symptoms?

> postgresql-8.0.3-1PGDG


The *first* thing you should do is update to 8.0.8 and see if the
problem is still there.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote