Postgres Database

DB Set up

To set up the DB for the first time, from your bash terminal, navigate to the DB_script folder and run the following command: psql -h localhost -U postgres simulator-db < DB_create_script.sql

If you run into an issue about not being able to create the DB, from your IDE access the DB_create_script.sql file. Enter -- in front of line 23 in order to comment it out, and save the file. Then:

1. from your bash terminal psql -h localhost -U postgres
2. within the psql environment, run: CREATE DATABASE simulator-db
3. Exit the psql environment
4. navigate to the DB_script folder and run the following command: psql -h localhost -U postgres simulator-db < DB_create_script.sql