June 13, 2019
How can I clear the Columbus cluster job status page?
The cluster_jobstatus table can be found in the columbus_webapp database. You must first login to the Columbus server via ssh connection i.e. using PuTTY or Terminal.
You can erase the job status table through psql by connecting to the database and issuing the following commands *IMPORTANT* The command deletes all entries from the Columbus cluster job status page:
If logged in as the root user, switch to the 'columbus' account:
$ su columbus
Login to the columbus_webapp database:
$ psql columbus_webapp
Welcome to psql 8.3.11, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Issue the following command *IMPORTANT* The command deletes all entries from the Columbus cluster job status page:
columbus_webapp=> delete from cluster_jobstatus;