Update Older Version of Postgres

These steps assist migrating an older version of Postgres to the most recent. The upgrade process involves some extra steps and can be done by Arts Management Support team if you are not comfortable following the steps below.

Remember, do not attempt to try this unless you just made a backup of your database. Preferably, you should also have restored that backup on another machine for safety, logged into it using Theatre Manager to prove that you can restore a backup and that it has 100% integrity.

The steps are:

  1. Sign all users out of Theatre Manager and stop all TM Web Services
  2. Make a manual backup of the database using the terminal command php /Users/Shared/backupTM.php (and restore the backup to a 'test' database to ensure it works).
  3. Save the PG_HBA.CONF and the POSTGRESQL.CONF settings unique to this server
  4. Stopping the Postgres server
  5. Removing the old postgres server by running the un-installer found in the /Library/PostgreSQL/x.x directory.
    • This will only uninstall postgres and the services
    • Once complete, you will need to move (or delete) the /Library/PostgreSQL/x.x directory which now should contain only the 'data' folder.
    • The 'data' folder is retained only for temporary safekeeping until you have installed the next version of Postgres and restored your data satisfactorily.
  6. Installing the new postgres server using the Theatre Manager postgres installer for OSX
  7. Reconfiguring the parameters for postgres for PG_HBA.CONF and the POSTGRESQL.CONF
  8. Restoring the main database from the backup
    • Create the new database with the owner 'TheatreManager', and using encoding "UTF8'. If the TheatreManager user is not in the database, contact support right away and do not continue.
    • Restore the backup of the database
  9. setting up the backup job again
  10. If you previously set up the hot standby server, you will need to follow the complete installation steps for and set it up again for the new version of postgres.
    Replication is a feature of postgres and is automatically set up for cloud venues. Self service venues may set this up if they wish - the support team is unable to help you.