[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[cobalt-users] pgsql error
- Subject: [cobalt-users] pgsql error
- From: "mika" <mcev@xxxxxxxxxxx>
- Date: Tue Aug 27 08:58:01 2002
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
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