[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[cobalt-users] [Raq 3i] Problem with postgres database



Hi

Sorry for insist with my problem (and my english), but I see that fails with
cobalt postgres database can affect all of us...

Last cron.daily send me next message from vacuumdb script:

 NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (574) IS
NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (574)
IS NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (574)
IS NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (574) IS
NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (574)
IS NOT THE SAME AS HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (574)
IS NOT THE SAME AS HEAP' (561)

Last software I installed was All-Kernel_i386-1.1.pkg before this error. With
this error I see that disk managment of GUI don't work.

Trying to fix this problem dropped pg_attribute_relid_attnam_index from cobalt
database (one of the affected by the error). The Cobalt GUI don't work more
because the postgres problems.

How I repair cobalt postgres database? I tried recovering file index from
template1 but doesn't work. Vacuumdb don't repair indexes too.

Please, can anyone help me with cobalt postgres database? I need help ASAP.

Thanks!

Gines

- - - - -
Gines Gazquez
gines@xxxxxxxxxx
MadrynCom
http://www.madryn.com/servicios