Cobalt database is extremely large or the Index Tuples error or the Internal Server error under Active Monitor in the UI is occurring.

Export to PDF | Export to DOC

Problem:  Cobalt database is extremely large or the Index Tuples error or the Internal Server error under Active Monitor in the UI is occurring.

Solution:

Telnet to the box as admin
Type:

su -
cd /home/pgsql
su postgres

edit pg_hba.conf
change “local cobalt crypt” to “local all trust”

Type:

pg_dump cobalt > cobalt.dump

Type:

destroydb cobalt
createdb cobalt
psql cobalt < cobalt.dump

edit pg_hba.conf
change “local all trust” back to “local cobalt crypt”
exit back to root by typing exit
Type:

swatch

Leave a Reply

Your email address will not be published. Required fields are marked *