middleware talk:Globus/407/server

From Dgiref
Jump to: navigation, search

Cleanup RFT DB

The RFT database need to be cleaned when the local disc is full.

Here are the steps needed to do the cleanup of the RFT DB:

 /etc/init.d/globus stop
 /etc/init.d/postgresql stop
 cp -a /var/lib/pgsql/data/pg_hba.conf /tmp
 rm -rf /var/lib/pgsql/data
 su - postgres
 initdb
 /etc/init.d/postgresql start
 psql -c "CREATE USER globus"
 createdb -O globus rftDatabase
 cp /var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/pg_hba.orig
 cp -a /tmp/pg_hba.conf /var/lib/pgsql/data
 exit
 /etc/init.d/postgresql restart
 su - globus
 psql -d rftDatabase -f $GLOBUS_LOCATION/share/globus_wsrf_rft/rft_schema.sql
 exit
 /etc/init.d/globus start

WARNING: If the startup of the postgres server fails after initdb and in /var/lib/pgsql/pgstartup.log is a message like postmaster cannot access the server configuration file "/var/lib/pgsql/data/postgresql.conf": Permission denied then try: chcon -R -t postgresql_db_t /var/lib/pgsql/data and then again start postgresql.

Personal tools