Banner: Direct Access to Postgres

This guide explains how personnel can request direct access to Postgres databases via terminal server and firewall permissions.

Procedures

Process for Direct Access to Postgres database by DTS personnel

1. Submit a service request saying you would like direct access to your Postgres database. List database you are requesting. Subject line should be:
   • Postgres - Obtaining direct access to Postgres databases through terminal server
2. List username and the IP address of the machine you will be using to login to Postgres.
3. Create another ticket for firewall rule changes.
4. Go to Forms page: https://www.oakland.edu/uts/forms/
5. Click on form Firewall Change Request
   • ALL areas within a red border are required fields.
6. Click on supplied link within form for help filling out the form.
7. Under Proposed Firewall Changes:
   • Enter your Source IP from the machine you will be logging into the Postgres database with.
   • Destination machine is either the Test or Production databases:
     • Test: 141.210.8.179
     • Production: 141.210.8.178
   • Application: Postgres
   • Protocol: TCP
   • Port: 5432
   • Action: Permit
     • One line for Test and one line for production if both are needed.
   • In the Reason For Request…, box put ticket number of the Ticket you created earlier to get direct access to Postgres.
8. Make sure you enter all areas with a red border then submit.

Additional Support

• OU Technology Center
• 44 Oakland Center
• Rochester, MI 48309-4479
• (248) 370-4357
• Office Hours: M-F 8:00am - 5:00pm