Re: index problems - Mailing list pgsql-general

Brook Milligan wrote:

> I am getting the following messages when I VACUUM ANALYZE:
>
> NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (3579) IS NOT THE SAME AS HEAP' (4517).
>         Recreate the index.
> NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (3579) IS NOT THE SAME AS HEAP' (4517).
>         Recreate the index.
>
> How do I recreate these indexes?  Is this a symptom of greater
> problems?
>

Unfortunately ordinary commands couldn't recover the corrupted
system indexes.　7.0 has REINDEX command to recover system
indexes. Please do as follows.

1. Stop the postmaster running.
    pg_ctl -w stop

2. Invoke a standalone postgres.
   postgres -P -O your_database_name

3. recreate the indexes using REINDEX command.
   reindex table pg_attribute force;

4. press cntrl-D to exit the program.

5. restart postmaster.

Regards.
Hiroshi Inoue