Version 22 (modified by bartek, 12 years ago) (diff)

--

QCG-Notification update instructions

In most cases the update of the QCG-Notification is straightforward and doesn't need any additional work beyond typical operations (e.g. 'rpm -U' in case of RPMs). Nevertheless, some updates may require changes in configuration files or/and database schema. The following list of instructions corresponds only to the updates that need such a special treatment.

Update to 2.6.x

In version 2.6.x of QCG-Notification the database schema has changed so the database used by the installed service must be updated as well. Note that all data stored in the database will be removed.

  1. Login as root.
  2. Turn off the QCG-Notification service (e.g. /sbin/servide qcg-ntfd stop).
  3. Update the service in a typical fashion (e.g. rpm -U qcg-ntf-2.6.2-2.x86_64.rpm, yum update qcg-ntf).
  4. Update the QCG-Notifcation database. For installation from RPMs you can use the script installed in /opt/plgrid/qcg/share/qcg-ntf/qcg-ntf-update.sh. Alternatively you can change the database manually with the SQL script: /opt/plgrid/qcg/share/qcg-ntf/qcg-ntf-psql.sql.
  5. Re-run the QCG-Notification service (e.g. /sbin/service qcg-ntfd start).

Example

$ sudo bash
# /sbin/service qcg-ntfd stop
Shutting down qcg-ntfd:                                    [  OK  ]
# yum update qcg-ntf
...
# /opt/plgrid/qcg/share/qcg-ntf/tools/qcg-ntf-update.sh 
Welcome to qcg-ntf update script!

This script will guide you through process of updating QCG Notification service. 
You have to answer few questions regarding parameters of your database. 
If you are not sure check the values in QCG-Notification configuration file. 

Use local PostgreSQL server? (y/n) [y]: 
Database [qcg-ntf]: 
User [qcg-ntf]: 
Password [qcg-ntf]: 

Checking for system user qcg-ntf...OK 

Performing installation
  
Schema update
 * Creating database schema...OK

# /sbin/service qcg-ntfd start
Starting qcg-ntfd:                                         [  OK  ]

}}}