Step 2: Create the Initial User and Import Demo Database (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

After the database server is installed, we need to create a specific user called TheatreManager and give them privileges. We also want to import a demo database. This step assumes that you have installed things into the C: drive into a directory called C:\BoxOffice. If you did not, then you will need to edit the bat files and do this step manually

1.

go to C:\BoxOffice directory. You should see some files and folders with names that look like below

Import1
2.

Double click on the 'ImportDemo' bat file that is highlighted above. This will start a DOS prompt and start the bat file running.

Note: if the server is 64 bit, then you will need to change the ImportDemo.bat' file to refer to C:\Program Files (x86).

If you altered the install directory, you will need to change the path name to point to the location that Postgres was installed in. Normally, this is just changing the drive letter.
3.

You will be asked for the password in order to create the 'TheatreManager' user. Type the password you used for the installation of the database in the preceding section. If this is a demo database install, this might have been 'master' that you used when installing the server.

Note: the password will not be echoed to you and you will not see the cursor move. There is no visual feedback that even a character was typed. You'll just have to get it right. If any of the steps are not right, you can start at the top of this step at any time.

import2
4.

You will be asked for the password in order to create a 'TheatreManagerDemo' database. Type the same password used above and elsewhere in the install instructions

import3
5.

You will be asked again for the password in order to import data into the TheatreManagerDemo database. Type the same password again and you will see a lot of lines displayed to you after that point as the demo database is imported.

step4

Step 3: Install Theatre Manager on the server machine and access the database