RE: [cobalt-users] Cron <root@www> run-parts /etc/cron.daily

[aljuhani <aljuhani@xxxxxxxxx>]

Hello,

This is caused by posgreSQL database being corrupted.  Below the fix from 
Cobalt:

SSH to the Server and then root
cd /home/pgsql 
su postgres 
edit pg_hba.conf 
change "local cobalt crypt" to "local all trust"
pg_dump cobalt > cobalt.dump 
pico cobalt.dump 
find create_table for quota and hash it out
close 
destroydb cobalt(RaQ3) or dropdb cobalt(RaQ4)
createdb cobalt 
psql cobalt < cobalt.dump 
edit pg_hba.conf 
change trust back to crypt

then type:

swatch

aljuhani@xxxxxxxxx

>===== Original Message From cobalt-users@xxxxxxxxxxxxxxx =====
>I wrote about this the other day and got no replies, so I'm trying again
>... the following message shows up at 5AM each day (today was the 3rd day
>in a row); anyone have ideas on what this is and what to do about it. Each
>morning it is slightly different, I rebooted to see if that would solve it
>but it did not. THANKS!!
>
>Subject: Cron <root@www> run-parts /etc/cron.daily
>
>NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (575)
>IS NOT THE SAME AS HEAP' (562)
>NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
>(575) IS NOT THE SAME AS HEAP' (562)
>NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES
>(575) IS NOT THE SAME AS HEAP' (562)
>META vacuum - FAIL: ERROR:  cannot find attribute 1 of relation quota
>
>_____________________________________
>cobalt-users mailing list
>cobalt-users@xxxxxxxxxxxxxxx
>To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
>http://list.cobalt.com/mailman/listinfo/cobalt-users