SQL Databases
Database Management Systems (DBMS)
OIT currently offers support for open-source PostgreSQL and MySQL databases for academic use. All databases must have an associated department and faculty member.
There are a number of factors that can determine which Database Management System (DBMS) is most effective for your research needs.
Quick links:
Request Access
Want to get started?
Any user with an PSU ODIN-ID (username) can request access to any of our systems using the PSU Help Desk form. Be sure to be specific about what system you want access to, why you are requesting access, and which department/faculty member you are working with.
Prerequisites
You will need the account credentials provided to you by the OIT-RC admin after you have been approved access.
You must be accessing the DBMS from a client system that has the DBMS Client installed (install steps here: PostgreSQL or MySQL).
Many on campus servers have this already configured (i.e. linux.cs.pdx.edu).
To login remotely to an RC system follow these steps.
You can also install on your own machine (the newer versions will most likely be backwards compatible with our older versions).
OIT-RC Database Systems
Quick Connect (More information here)
$ psql -h learn-pgsql.rc.pdx.edu -U username database_name