[cobalt-users] NUMBER OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP

[Scott F <scott_falco@xxxxxxxxx>]

Been through this a few times... One of the guys at
Cobalt passed me the instructions regarding how to fix
it myself, so here ya go... But if you're not
comfortable doing this, I'd put a call into Cobalt for
assistance.. 

Use at your own risk:

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 

Good Luck!
Scott

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/