Other: Updating an installation of PostgreSQL Server (PC & Mac)

For reference, the list of steps are:

  1. the installation of the PostGres SQL server
  2. installing the demo database and the main TheatreManager User
  3. install Theatre Manager and connect to the database
  4. configuration of the server parameters for a production database
  5. creating a daily backup job in Windows Task Scheduler to run the backup

If you have already installed the Postgres database engine on a serve and need to update it, then the following are possible. In general, follow the update steps. Removing and installation of postgres will cause all data to be lost.

Updating Postgres

download the latest postgres installer from the Artsman web site. Once you have it, make sure you have done the following steps:

  1. Check the version of postgres you are running. This is in the 'About Theatre Manager' menu. Verify that the version is at least 8.3.0 by looking at the bottom left of the about screen. You will see your database name followed by (8.3.x). If you have version 8.2.x, do not attempt the upgrade process.
  2. If you have version 8.3.0 or later, log everybody out of Theatre Manager, including web listeners
  3. Make sure you have made a backup of the database, using the procedures in the daily backup job process
  4. Once you have confirmed the backup exists and have made another copy of that in a different place (just to be safe), then follow the specific instructions for your platform.

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.
PCs:
  1. Make sure you are running postgres version 8.3.0 or later.
  2. Download the latest TMPostGresSetup installer
  3. run the TMPostGresSetup installer.
    1. This will place all the install files into the C:\BoxOffice folder.
    2. Do not install the latest version when asked by the installer
    3. Let the installer complete and quit out of it.
  4. Go to C:/BoxOffice and find the latest version of postgres. It will have a folder name similar to the one below - with a different version number on it reflecting the latest one. As of APril 2009, the current shipping folder will be 'Postgresql-8.3.7-1' or later.
  5. Look for the file called upgrade and double click on it.

    upgrade1

  6. It will start up the dos prompt and you will see a screen like below

    upgrade 2

  7. Follow the instructions by hitting any key to do the upgrade.
  8. At the end you will need to restart the server.
  9. Check that you can log in to Theatre Manager from the serer or any workstation.
    1. If the Postgres Service did not start, make sure that the Postgres User password (system settings or active directory) is the same as the password for the Postgres Service in the services panel
    2. If Postgres did startup, you are done.

 
Macs
  1. Make sure you are running postgres version 8.3.0 or later.
  2. Download the latest Mac Installer for postgres
  3. Make sure you have just made a backup of the databases in the server
  4. use terminal and PG_CTL to STOP the database
    a) start terminal
    b) type su - postgres
    c) provide the password
    d) type PG_CTL STOP -m immediate

  5. Run the installer which will update and restart an existing PostgreSQL installation
  6. try log in to Theatre Manager afterwards
NOTE:

If you have postgres 8.2.x (or any version older than 8.3.0), the upgrade process involves some extra steps and will be done by Arts Management Support team. These are:

  1. making a backup of the database
  2. recording the PG_HBA.CONF and POSTGRESQL.CONF settings unique to this server
  3. stopping the server
  4. deleting the old postgres server data directories
  5. installing the new postgres server
  6. creating the new database (owner 'TheatreManager', Encoding "SQL_ASCII')
  7. Importing the new database
  8. redoing the configuration parameters for postgres (item 4 at the top of the page)
  9. setting up the backup job again
NOTE: If you have a linux postgreSQL server, you will have to have your IT department upgrade the server for you.
   

Removing an Installation

(PC)
  1. Run the PostGres installer and 'uninstall' the database first, and then run the install process -and/or-
  2. Delete the C:\Program Files\PostgreSQL folder -and/or-
  3. Remove the 'postgres' user from you list of users using the admin tools -and/or-
  4. make sure that the PostGres server is not running as a service and has been removed using RegEdit
(Mac)
  1. Stop the postgres database using the 'pg_Ctl stop -m immediate' command
  2. When the server is stopped, throw out the entire folder called /Library/PostgreSQL8
  3. restart the mac