[cobalt-users] RAQ4-postgres/gui errors and rebuild

[MC Gonzalez <mgonzalez@xxxxxxxxxx>]

Hi all!

I know my postgres DB is broken, I get the active monitor errors on the
disk space page(Internal error) and I get two different errors, swatch
gives this is the postgres log:

030604.01:15:02.623  [1976] ERROR:  quota: Permission denied.
030604.01:15:03.272  [1976] ERROR:  quota: Permission denied.
030604.01:15:03.293  [1976] ERROR:  Relation 'quota' already exists

And the weekly vacuum fails with the following:

NOTICE:  Index users_pkey: NUMBER OF INDEX' TUPLES (51) IS NOT THE SAME
AS HEAP' (72).
	Recreate the index.
ERROR:  Cannot insert a duplicate key into unique index users_pkey


I snagged Bruce's instructions for rebuilding from this message:

http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html

The problem is, I don't think it is the quota table that is broken, as
when I run the check in the first part of the procedure, I get the
following:

cobalt=# SELECT * FROM quota;
 type | name | total | free | used | percent | modify 
------+------+-------+------+------+---------+--------
(0 rows)


Although it is not an error, 0 rows is probably not right either.  So my
question is, should I go ahead with the quota rebuild as per the
instructions, or is it something else I should be looking at?

FWIW, I have also done the meta-verify stuff and it all comes out clean.
Thanks in advance!


-- 
MC Gonzalez <mgonzalez@xxxxxxxxxx>