1. Download the new tarball to a directory and unpack it:

mv ~/airt-20090121.tar.gz /opt/airt/src
cd /opt/airt/src
tar xfz airt-20090121.tar.gz
cd airt-20090121.tar.gz

2. Check for database upgrades

cd doc/database
ls -1 200[89]*

Checking the output reveals that we need to apply the following patches

20080523.1.sql
20080730.1.sql
20080731.1.sql
20080906.1.sql
20080924.1.sql
20081031.1.sql
20081219.1.data.sql
20081219.1.schema.sql
20081231.1.sql
20090121.1.sql

3. Apply the patches

psql airt airt < 20080523.1.sql
psql airt airt < 20080730.1.sql
psql airt airt < 20080731.1.sql
psql airt airt < 20080906.1.sql
psql airt airt < 20080924.1.sql
psql airt airt < 20081031.1.sql

Check the schema file-- it sets permissions!

psql airt airt < 20081219.1.schema.sql
psql airt airt < 20081219.1.data.sql
psql airt airt < 20081231.1.sql
psql airt airt < 20090121.1.sql

4. Check for configuration file changes

kees@airt-test:/opt/airt/src/airt-20090121.1$ cd /opt/airt/etc/airt
kees@airt-test:/opt/airt/etc/airt$ diff -U1 airt.cfg airt.cfg.dist
--- airt.cfg    2009-01-25 08:14:43.000000000 -0500
+++ airt.cfg.dist       2009-01-25 08:43:35.000000000 -0500
@@ -21,3 +21,3 @@
  *
- * $Id: airt.cfg.dist.in 1153 2007-07-31 09:23:11Z kees $
+ * $Id: airt.cfg.dist.in 1381 2008-12-05 19:11:07Z kees $
  */
@@ -47,2 +47,7 @@
    $SETTINGS['libdir'] = '/opt/airt/lib';
+
+   // identify clients by X509 certificates? Note: web server is
+   // expected to ensure the validity of the certificate. AIRT will
+   // look for the subject name.
+   $SETTINGS['x509client'] = true;

@@ -111,2 +116,5 @@

+   // instance name
+   $SETTINGS['incident_name'] = "Example AIRT Site";
+
    // local customization can be found in this file. If undefined, no local

New configuration options x509client and incident_name must be incorporated into current airt.cfg

5. update css

cd /opt/airt/php
cp airt-style.css.dist airt-style.css

6. You are done.