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

Re: [cobalt-users] POSTGRES Cobalt - Rebuild indexes



Hello  Bruce,

Thanks for your message . It works and the quota table has been
recreated by swatch.

Do I have to reboot the cobalt server now because I've got in the
cobalt monitor "Internal Server Error" with disk usage with yellow
bullet ( problem ) ?

>> but when I make the dump I've got a error  :
>>
>> SQL query to dump the contents of Table 'quota' did not execute.
>> Explanation from backend: 'ERROR:  cannot find attribute 1 of
>> relation quota '. The query was: 'COPY "quota" TO stdout; '.

BT> You need to edit the schema file that you dumped and remove the entire 
BT> quota table section, THEN rebuild the database.  Remember, the quota 
BT> table is broken, so the schema section has to be broken too.

BT> When swatch runs again (Active Monitor, every 15 minutes), it will 
BT> recreate the quota table properly.