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

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Monday 17 March 2003 02:35, aljuhani wrote:
> Hello,
>
> This is caused by posgreSQL database being corrupted.  Below the fix from
> Cobalt:
>
> SSH to the Server and then root
+++
if RaQ4 it is in /var/lib/pgsql/data
+++
> 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
>
> _____________________________________
> 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

-- 
http://frontstreetnetworks.com | http://store.raqware.com
Front Street Networks LLC      |  Phone: 203-785-0699
229 Front Street, Ste #C, New Haven, CT 06513-3203