Service Description
The Office of Information Technology (OIT) provides database hosting services to support research projects and instructional courses, offering both MariaDB and PostgreSQL (with PostGIS and pgRouting) options.
Service Details
- Granular Access Control: OIT will create individual authentication credentials and databases for each student and faculty member requested.
- Student Access: Students are limited to accessing only their assigned individual database and designated class/project-level databases.
- Faculty Access: Faculty members will have access to all databases associated with their class or research project.
- Class/Project Data Separation: Data for each class or project is isolated, ensuring members do not have access to data from other classes or projects.
- Data Responsibility: All databases are provided as empty instances. Users are responsible for all data loading, management, and operations within their databases.
- Service Availability: While we strive to maintain maximum uptime, this is not a fault-tolerant service. Issues can arise if queries consume excessive server resources. We strongly advise faculty to educate students on responsible querying practices to help maintain service stability.
Availability
This service is available to the following groups:
To ensure data security, access to this service is available only to students and faculty connecting via the physical campus network or PSU’s Virtual Private Network (VPN).
Charges and Fees
Research databases up to 100GB are provided free of charge. Usage beyond this costs $.35 per GB annually.
Note: unit multiples of data storage (e.g., MB, GB, TB) are intended to mean their versions based on powers of two: most precisely MiB, GiB, TiB, etc.