Tom, Currently we are using version 9.0.1.
Which version shall we update to? 9.05 or 9.1 ? ~Bhakti On Fri, Nov 4, 2011 at 7:44 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Bhakti Ghatkar <bghat...@zedo.com> writes: > > Hi , > > While performing full vacuum we encountered the error below: > > > > INFO: vacuuming "pg_catalog.pg_index" > > vacuumdb: vacuuming of database "xxxx" failed: ERROR: duplicate key > value > > violates unique constraint "ccccc" > > DETAIL: Key (indexrelid)=(2678) already exists. > > > We are using Postgres 9.0.1 > > > Can you please help us out in understanding the cause of this error? > > Try updating ... that looks suspiciously like a bug that was fixed a few > months ago. > > regards, tom lane >
