Macintosh PostgreSQL Server

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

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 if you are using the Theatre Manager TMPostgresSetup installer program; 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 PostgreSQL installer for Mac	yes	yes
2	the installation of the PostgreSQL SQL server	yes	yes
3	configuration of the server parameters for maximizing performance in a production database	yes	no
4	creating a daily backup job using TM Server	yes	no
5	Turn off energy saving, airport and other energy saving features	yes	no
6	(Optional) Implement hot database standby server depending on load and other considerations.	no	no

Notes and Assumptions:

• This install process will install or update PostgreSQL. If you are updating across versions, you may need to refer to Updating PostgreSQL Instructions
• You MUST turn off 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 and 2.