Linux PostgreSQL Server

The following instructions are used to set up a Linux PostGreSQL server for use with the Theatre Manager application. Click if you are doing Windows setup or Click if you are doing Macintosh setup.

As of Oct, 2010, the current minimum acceptable version of Postgres is 8.4.4 (or later). Theatre Manager has been tested with version 9.0 and works with the bytea_encoding set to escape (see parameters in step 4).

The server needs to be set up on one machine and the application can be set up on as many machines as you wish.

Follow these steps and you may want to bookmark this page in your browser in case you want to refer to these installation steps. If you are only installing a demo, refer to the last column for required steps.

task	Description	Full Install	Demo
1	download the PostGres installer for Linux from Postgresql.org	yes	yes
2	the installation of the PostGres SQL server	yes	yes
3	installing the demo database and the main TheatreManager User	optional	yes
4	configuration of the server parameters for maximizing performance in a production database	yes
5	creating a daily backup job in using cronnix to run the backup	yes

Notes and Assumptions:

• This install process assumes you have NEVER installed PostGres or Theatre Manager on your computer before. If you have, you may need to refer to Updating Postgres Instructions
• You MUST turn all virus protection while running the installer (especially Norton if you are using it). Virus software always interferes with proper software installation.
• If this installer is being used to create a demo installation, then you only really need do steps 1, 2 and 3.
• This process assumes that you have never installed Theatre Manager or Postgres on your machine. If you have already installed Postgres:
  • you will be asked if you want to un-install Postgres (you may want to do that and then try to re-install after)
  • you may need to remove the 'postgres' user from your computer if one exists, unless you know the password for the use.