Step 2: Create user and import Database

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 /Users/Shared directory. If you did not, then you will need to edit the script and do this step manually

Import1

Go to /Users/Shared directory. You should see some files and folders with names that look like below.

import2 Start terminal and change the user to 'postgres' by typing:

su - postgres

Press

and the postgres user's password (password will not display anything)

import3 Drag the script '/Users/Shared/CreateDemoDB.sql onto the terminal window. This shortcut saves typing anything.

Click on the terminal window and then press to start the command.

If it does not run, then possible issues are:

You need to have execute permissions on the 'CreateDemoDB.sql' script. Use File Examiner to check or fix that (or use unix chmod commands to give permission).
Make sure that postgres was configured with 'trust' permissions for the local machine.
Make sure that postgres was installed into the /Library/Postgresql8 directory.

step4 The script will run and load up the TheatreManagerDemo database.

You can modify this script to load up a customer database if neccessary by editing it in BBedit or in textedit (make sure to save it as text if you use textedit - its preference, unfortunately, is to save as an rtf document).

Note, any WARNING messages from the TheatreManagerDemo database creation can be ignored. These warnings are normal.

1.	Go to /Users/Shared directory. You should see some files and folders with names that look like below.
2.	Start terminal and change the user to 'postgres' by typing: su - postgres Press and the postgres user's password (password will not display anything)
3.	Drag the script '/Users/Shared/CreateDemoDB.sql onto the terminal window. This shortcut saves typing anything. Click on the terminal window and then press to start the command. If it does not run, then possible issues are: You need to have execute permissions on the 'CreateDemoDB.sql' script. Use File Examiner to check or fix that (or use unix chmod commands to give permission). Make sure that postgres was configured with 'trust' permissions for the local machine. Make sure that postgres was installed into the /Library/Postgresql8 directory.
4.	The script will run and load up the TheatreManagerDemo database. You can modify this script to load up a customer database if neccessary by editing it in BBedit or in textedit (make sure to save it as text if you use textedit - its preference, unfortunately, is to save as an rtf document). Note, any WARNING messages from the TheatreManagerDemo database creation can be ignored. These warnings are normal.

Step 2: Create the Initial User and Import Demo Database (Macintosh)