undead index

From: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: undead index
Date: 2011-05-04 12:11:15
Message-ID: 201105041411.15561.jens.wilke@affinitas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

pg_upgrade brakes with the following error:

pg_upgrade 8.4.5 to 9.0.4:
Restoring user relation files
/data1/postgres/pgsql/foo/data_8.4/base/11564/2613 ^M
/data1/postgres/pgsql/foo/data_8.4/base/11564/2683
Could not find foo.bar_idx in old cluster

This index was deleted several weeks ago.

server_version | 8.4.5

foo=# select * from pg_class where relname = 'bar_idx';
(No rows)

after pg_dumpall|psql from 8.4 to 9.0 the undead index revived on the target
DB:

server_version | 9.0.4

foo=# select * from pg_class where relname = 'bar_idx';
-[ RECORD 1 ]---+------------------------------------
relname | bar_idx
relnamespace | 16409

Besides the question how this could happen, Is there another way to correct
this without using dump|restore?
I'd like to get pg_upgrade working.

Regards, Jens

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Curvey 2011-05-04 12:12:06 Re: postgres segfaulting on pg_restore
Previous Message Gabriele Bartolini 2011-05-04 11:16:38 Re: multiple group by on same table