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

[cobalt-users] pgsql error



Till i'm back from holidays i got in the root's mailbox this kind of
messages:
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)
META vacuum - FAIL: ERROR:  cannot find attribute 1 of relation quota

I tried this solution unseccesfully :
telnet to the box & become root
            cd /home/pgsql
            su postgres
            edit pg_hba.conf
            change crypt to trust
            pg_dump cobalt > cobalt.dump
            vi cobalt.dump
            find create_table for quota and hash it
out ( comment it out )
            close
            destroydb cobalt
            createdb cobalt
            psql cobalt < cobalt.dump
            edit pg_hba.conf
            change trust back to crypt
            swatch

Things are getting worse now...The problem is not solved and one more
appeared. All domains and users registered on the raq appear twice now in
the admin gui.
Don't know what to do. Please help.

Thanks in advance.

Mike