Installation Guide for Testing ESP: MDPHnet

Owned by Alison Leibowitz (Unlicensed)
Last updated: Jun 23, 2014 by Melanie Davies (Unlicensed)
2 min read

A sample ESP: MDPHnet database is available if your site is interested in testing the PopMedNet™ software using an ESP: MPDHnet data model. 

The database is a Postgres database accessible from the pgAdmin application. Follow the instructions below to install pgAdmin and the ESP: MDPHnet database.

Click below to download the sample ESP: MDPHnet database.

ESP.zip

1. Install Postgres 9.x.x

  1. Download the software from: http://www.enterprisedb.com/products-services-training/pgdownload#windows
  2. During the installation process, you will be prompted for several different pieces of information. Enter the following when appropriate:
    1. Password: Password1!
    2. Port: 5432
    3. Location: Default
    4. Username: esp_mdphnet
  3. When the installation is complete, click 'Finish'
  4. When prompted for a username, select 

2. Restore the test ESP: MDPHnet database:

  1. Launch the pgAdmin III application from your Start menu
  2. Locate the 'Object browser' on the left hand side of the screen
  3. Expand Server Groups > Servers > PostgresSQL 9.x (localhost:5432) > Databases.
  4. Right click on Databases and select “New Database…”.
  5. Type “esp_mdphnet” for name.
  6. Click OK to create the database.
  7. Right click on the newly created esp_mdphnet database on the left panel and select Restore…
  8. Select ‘…’ and navigate your computer to find the database backup file. See above for a zip file containing the test ESP: MDPHnet backup file. This file should be unzipped before being selected during this step.
  9. Click Restore. Ignore errors and warnings, click “Cancel” when it is finished.
  10. Right click and refresh Server Groups > Servers > PostgresSQL 9.x (localhost:5432) > Databases.
  11. Expand Server Groups > Servers > PostgresSQL 9.x (localhost:5432) > Databases > esp_mdphnet > Schemas > esp_mdphnet > Tables. There should be 27 tables. Note that the database is restored to the schema “esp_mdphnet”, which is the same name as the database and the user (see below if you use a different user name).

 

3. (Optional) If you provide a user name different from “esp_mdphnet”, then additional setup steps are needed.

Postgres uses the concept of search path to find tables that are unqualified in SQL statements. Search path is a list of schemas. By default, Postgres searches only the schema with the same name as the login user and the public schema. The DataMart Client makes use of the search path. There are two ways of ensuring the ESP database is in the search path:

  1. Create an “esp_mdphnet” user and grant it rights to the “esp_mdphnet” schema (recommended).
    1. Launch pgAdmin III.
    2. Select the “esp_mdphnet” database.
    3. Right click “Login Role” under the “esp_mdphnet” database and select “New Login Role…”
    4. Enter “Role name” as “esp_mdphnet”, add a password under “Definition” tab and check off “Superuser” under the “Roles privileges” tab.
  2. Alter the login user’s search path to include “esp_mdphnet”.
    1. Launch pgAdmin III.
    2. Select the “esp_mdphnet” database.
    3. Click the “SQL” icon on the toolbar.
    4. Type: ALTER USER <your user> SET search_path TO “$user”,public,esp_mdphnet
    5. Go to Windows’ Control Panel > Administration > Services. Restart Postgres