[cobalt-users] POSTGRES Cobalt - Rebuild indexes

[Frederic <journal@xxxxxxxxxx>]

Hello

here is the result cron message every day

NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (574) IS NOT THE SAME AS HEAP'
(561)
NOTICE:  Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (574) IS NOT THE SAME AS
HEAP' (561)
NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (574) IS NOT THE SAME AS
HEAP' (561)

I try to connect to cobalt postgress database and obviously there is
some mistakes are into the quota table on the postgres Cobalt database
on my Raq.

cobalt=> select * from quota;
ERROR:  cannot find attribute 1 of relation quota

Before I try anyhing, I dumped the database

pg_dump -D -u -f dump.psql cobalt

but if necessary I notice there is no pg_restore on the cobalt ??

QUESTION 1 : HOW COULD I RESTORE FROM THE DUMP IF NECESSARY ?

QUESTION 2 : could I do this :

/usr/bin/psql -D /home/pgsql/base/ -O -P cobalt -o reindex_psql.log

without any problem ???


Maybe you have solved this problem before and you can send solution.


THANKS IN ADVANCE


Frederic