Step 1: Install the PostGreSQL Database Server (PC)

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

Caution: Please read to see if this applies to your installation:

1.

When you run the installer for the database, accept all the defaults. This will put the actual installer files into a C:\BoxOffice directory along with all the support files needed for the rest of the steps. Note: If you have multiple drives, you may want to install the database server on a larger data drive like D:\BoxOffice

At the and of the TM PostGres installer, you will be asked if you want to actually install the PostGreSQL database in the dialog below.

PGInstall

If you say yes, follow the instructions in step 2. Alternatively, you can do this later manually by:

  • going to C:/BoxOffice
  • clicking the PostGresInstall Icon
  • Follow the instructions in step 2.
2.

Accept all the defaults on the screens that follow except the last one that references 'stackbuilder'.

Click next Step1
Click Next

Step2

NOTE: if you wish to install PostGres on another drive instead of the C: drive, click the Browse button and select another drive.

  • If you change this, you must also change the backupTM.bat files later to refer to this other drive.
  • If you changed the install location to D:\BoxOffice, this should have already changed for you in this window

NOTE: please be aware that the standard install location depends on 32 or 64 bit version of the operating system

  • If you are using 32 bit server, the standard install location starts with C:\Program Files\PostgeSQL ..
  • If you are using 64 bit server, the standard install location stars with C:\Program Files (x86)\PostgreSQL ...
Click Next Step3
Click Next

Accept the default for the ' Account Password' for the postgres user. However, if this is a demo. In that case, please pick a user password that you remember - we suggest 'Master'.

NOTE: For a purchased version of Theatre Manager, this will be set up for you by your trainer who will use a specific AMS password for this server that should not be changed. The

Click Next

Leave the Port Number as 5432 (if you change the standard port, you will also have to change it in Theatre Manager login window)
Click Next

Setup6

Leave both these settings as shown.
Click Next Step7
Click Next

You will need to wait for a bit while the database server is installed

Step8
Click Finish

Important: Uncheck the 'Launch Stackbuilder at Exit' setting. There are no additional modules to install into your database at this time.

At this time, the database should have installed successfully and shoudl be runnning.

Step9
3.

You may be given an option to install a demo database.

If you would like to do this, click 'Yes'. It is recommended that you do.

Click Yes Install Demo
Wait

Wait while a DOS window pops up and shows the progress of the demo database being imported. Depending on the performance and RAM in your machine, this coudl take a few minutes to finish.

install
  When the DOS window closes, the database server is installed, and the TheatreManagerDemo database is imported.

Step2: Install the demo database and the main TheatreManager User (if you did not do so as part of the install).