Independent, vendor-neutral open source certifications

Certifications / DB-OPS-PSQL

DB-OPS-PSQL

OSPI Certified: PostgreSQL Administrator

Prove practical PostgreSQL administration skills in a 2.5-hour performance-based lab on Ubuntu LTS.

OSPI Certified: PostgreSQL Administrator exam badge

Who should take this exam

You should take this certification exam if you are a database administrator, platform engineer, or backend developer who owns PostgreSQL instances in open source or hybrid environments.

Prerequisites

  • Comfort with the Linux command line on Ubuntu LTS.

Exam details

Assessment type Performance-based lab
Format Remote live lab in an isolated Linux environment
Duration 2.5 hours
Platform Ubuntu LTS + PostgreSQL
Price $299 USD planned (one examination attempt)
Language English
Enrollment Coming soon
Documentation PostgreSQL documentation permitted in the browser during the exam

Exam objectives

  1. 1. Installation and instance lifecycle
    • Install and start PostgreSQL using distribution-appropriate methods
    • Create databases, roles, and grants aligned to a scenario
    • Verify connectivity and basic health checks
  2. 2. Configuration and security
    • Adjust key parameters for the exam workload (memory, connections, logging as specified)
    • Configure host-based authentication and least-privilege access
    • Apply extensions or settings required by the blueprint
  3. 3. Backup, restore, and maintenance
    • Perform logical or physical backups as directed by the tasks
    • Restore data to a required point-in-time or snapshot state
    • Run routine maintenance commands appropriate to the scenario
  4. 4. Monitoring and troubleshooting
    • Inspect logs and catalog views to diagnose failures
    • Identify blocking queries or resource pressure introduced in the lab
    • Return the instance to a healthy, task-compliant state

OSPI is an independent certification body and is not affiliated with, sponsored by, or endorsed by the PostgreSQL Global Development Group or other vendors named in this description. PostgreSQL is a trademark of the PostgreSQL Global Development Group.