Update or Remove PostGreSQL

If you have already installed the Postgres database engine on a server and need to update it, then follow the update steps. Removing and installing postgres will cause all data to be lost, so you must have just made a backup before starting.

These steps are valid if you are using version 9 of Theatre Manager or later.

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 9.1 by looking at the bottom left of the about screen. You will see your database name followed by (9.1.x). If you have version 9.0.x or earlier, do not attempt the upgrade process.
2. If you have version 9.1.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.

1. Make sure you are running postgres version 9.1.0 or later.
2. Refer to the overall instructions to 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 file with a name similar to the one below - with a different version number on it reflecting the latest one. As of November 2011, the current shipping vesrion will be 'Postgresql-9.1.1-1' or later.
5. Double click on it.
6. It will start up the installer and default most of the settings based on the existing installation.
7. Follow the instructions and you will generally only need to use the 'next' key to continue (a few times) until the upgrade (or install) begins.
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.

Upgrading older Versions of Postgres

If you have postgres 9.0.5 (or any earlier version), 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. 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 "UTF8')
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

Removing an Installation

1. Preferred Method:
   1. Go to Setup->Settings->Control Panel->Add/Remove Programs
   2. Find the line that refers to your Postgres installation
   3. Use the remove option
   4. Delete the C:\Program Files\PostgreSQL folder to remove your database
2. Secondary Method:
   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