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 wrote:
> Bhakti Ghatkar writes:
> > Hi ,
> > While performing full vacuum we encountered the error below:
>
>
> > INFO: vac
Hi ,
While performing full vacuum we encountered the error below:
INFO: vacuuming "pg_catalog.pg_index"
vacuumdb: vacuuming of database "" failed: ERROR: duplicate key value
violates unique constraint "c"
DETAIL: Key (indexrelid)=(2678) already exists.
We are using Postgres 9.0.1
Ca
Tom,
The query which you gave returns me 0 rows.
select ctid,xmin,xmax,* from pg_index where indexrelid in
(select indexrelid from pg_index group by 1 having count(*)>1);
Regards,
Bhakti
On Sat, Feb 26, 2011 at 10:55 PM, Tom Lane wrote:
> Bhakti Ghatkar writes:
> > We
Hi,
We were running full vacuum on DB when we encountered the error below;
INFO: analyzing "public.bkup_access_control"
INFO: "bkup_access_control": scanned 14420 of 14420 pages, containing
1634113 live rows and 0 dead rows; 3 rows in sample, 1634113 estimated
total rows
INFO: vacuuming "p