Skip site navigation (1) Skip section navigation (2)

Re: Index corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Munro <marc(at)bloodnok(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index corruption
Date: 2006-06-28 17:20:36
Message-ID: 28056.1151515236@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Marc Munro <marc(at)bloodnok(dot)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

In response to

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2006-06-28 17:38:50
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as
Previous:From: A.M.Date: 2006-06-28 17:18:39
Subject: Re: Fixed length datatypes. WAS [GENERAL] UUID's as

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group