PostgreSQL Instructions

  1. Open pgAdmin III
  2. Double-click on desired server (i.e. PostgreSQL 9.3 (localhost:5432))
  3. Right-click on Databases
  4. Select New Database…
  5. Enter "clinic" for the Name
  6. Click on OK
  7. Click on the clinic database in the Object Browser
  8. Click on Execute arbitrary SQL queries (SQL icon in the toolbar)
  9. Click on Open File (Ctrl+O)
  10. Select the clinic.sql file from this folder
  11. Click on Execute pgScript (second green play icon in the toolbar)
  12. Right-click on Login Roles in the Object Browser
  13. Select New Login Role…
  14. Enter "clinic" as the Role name
  15. Click on the Definition tab
  16. Choose and confirm a password
  17. Click on the Role privileges tab
  18. Check the Superuser checkbox
  19. Click on OK
  20. Use the PostgreSQL Application Stack Builder to install Npgsql (Categories -> Database Drivers -> Npgsql), if not already installed
  21. Open the clinicPostgreSQL.cfg file in this folder
  22. Replace the orange text in the following line with the password chosen in step 16:

    connectionString = "Server=localhost;Port=5432;Database=clinic;UID=clinic;PWD=password"

    Ensure the Port number in the connection string is correct

  23. Move the clinicPostgreSQL.cfg file from this folder to the dbiScript\data folder
  24. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicPostgreSQL.cfg"

  25. Navigate to http://localhost/dbiScript/apps/clinic/