Here are the basic tools for starting your local PostgreSQL server and building the monopoly database on Windows.

  1. Start PostgreSQL as follows.

    1. In the likely case that the database service is not running (PostgreSQL is configured for manual starting in the lab), run Windows “Component Services”, find the local PostgreSQL service and “Start” it.
    2. Choose Start→All Programs→PostgreSQL 9.4→PGAdmin III. Note that there may be older versions of PostgreSQL installed on the system.
    3. Click mouse-right on the main server and choose “Start Service”.
    4. Click mouse-right on the main server and choose “Connect”, entering the appropriate password (“postgres”).

    This sets up the service on your local machine and gives you administrator control over the databases. The work that you do will be done on the local machine and can’t be ported to other machines.

  2. Create the monopoly database as follows.

    1. Select the monopoly database. If necessary, create it first and specify that it be owned by postgres.
    2. Start up the PostgreSQL query tool (by choosing Tools→Query tool ) and cut/paste the monopoly.sql file into the SQL Editor.
    3. Run the SQL commands by pressing the green arrow button.

    This will automatically delete the old tables and build new ones. You can update the database by editing the script and re-running as needed.

  3. When you are finished, disconnect the database by going to PGAdmin III, clicking mouse-right on the main database and choosing “Disconnect”.

This should work on all lab machines, but each machine keeps a separate database space, so you will need to rerun the build/load script on each new machine.