OSPI Certified: PostgreSQL Administrator (DB-OPS-PSQL) is a 2.5-hour performance-based exam on Ubuntu LTS with PostgreSQL 16. You SSH into an isolated lab and complete administration tasks under a time limit: provision roles and databases, deploy schema, tune access, adjust server configuration, run logical backups and restores, perform maintenance, and configure WAL archiving. There is no multiple-choice section. The grader checks what you actually did on the server.
The credential is valid for three years and can be verified publicly at ospinstitute.org/verify. Enrollment is $249 USD for one attempt.
If you are comparing PostgreSQL credentials in 2026, DB-OPS-PSQL is the one built for that operational proof. Most other options on the market test recall instead. EDB Essentials and Advanced are online multiple-choice exams with strong brand recognition. Udemy and similar platforms issue course completion certificates after self-paced video. EDB instructor-led training prepares teams for the Essentials exam but is not a certification by itself.
This post walks through five credentials candidates ask about most often: what each one tests, what it costs, and when it is worth pursuing. EDB remains a fair choice when a job posting or training catalog names that badge specifically. For proving you can administer PostgreSQL on Linux under time pressure, OSPI is the clearest fit on this list.
At a glance
| Credential | Format | What it proves | Typical cost |
|---|---|---|---|
| OSPI PostgreSQL Administrator (DB-OPS-PSQL) | Live Linux lab (SSH) | PostgreSQL 16 ops on Ubuntu: roles, schema, auth, backup, WAL | $249 USD |
| EDB Essentials for PostgreSQL | Online multiple choice | Foundational PostgreSQL knowledge recall | $200 USD |
| EDB Advanced for PostgreSQL | Online multiple choice | Advanced PostgreSQL concepts recall | $200 USD |
| Udemy: PostgreSQL Bootcamp | Video course + labs | Course completion only | Often $15-20 on sale |
| EDB Essentials for PostgreSQL training | Instructor-led (4 days) | Prep toward EDB Essentials; includes one exam attempt | Varies (contact EDB) |
Prices change. Check the issuer before you enroll. Last reviewed June 2026.
Top pick: OSPI PostgreSQL Administrator
DB-OPS-PSQL is built for the gap EDB’s multiple-choice exams leave open. Exam day is a timed Linux lab, not a browser quiz. You work through real administration tasks on PostgreSQL 16 while the clock runs.
OSPI Certified: PostgreSQL Administrator
Open Source Proficiency Institute
- Format
- Performance-based live lab (SSH)
- Duration
- 2.5 hours
- Price
- $249 USD
- Validity
- 3 years
Best for: DBAs and platform engineers who need proof they can operate PostgreSQL on Linux, not just answer questions about it.
Strengths
- Live Linux lab: roles, schema deployment, pg_hba.conf, logical backup/restore, WAL archiving
- Vendor-neutral PostgreSQL 16
- 3-year credential with public verification
Watch outs
- Less HR keyword recognition than EDB Essentials today
- Requires solid Linux CLI and psql habits under time pressure
- Wrong pick if the posting requires the literal “EDB” badge name
Why OSPI wins for PostgreSQL administration
PostgreSQL administration is operational work. You edit configuration files, grant least privilege, run maintenance, and recover from a bad restore. A passed multiple-choice exam shows you studied the topics. A passed live lab shows you executed them on a server someone else could hand you on Monday morning.
DB-OPS-PSQL weights its four domains the way working DBAs spend time: schema and access (35%), backup and maintenance (25%), instance lifecycle (20%), and configuration plus connectivity (20%). That is closer to a production handoff than a 60-minute recall sprint.
At $249 USD, OSPI costs slightly more than EDB Essentials ($200). You get a longer sitting, scored task work instead of selected answers, and a three-year credential instead of a version-tagged digital badge that hiring teams may not recognize two major releases later.
Other credentials worth knowing
EDB Essentials for PostgreSQL
EDB (EnterpriseDB)
- Format
- Online multiple choice
- Duration
- 60 minutes (~50 questions)
- Price
- $200 USD
- Validity
- Digital badge (version-specific)
Best for: Candidates who need the most recognized PostgreSQL exam title on a resume or internal training record.
Strengths
- Strongest brand recognition among PostgreSQL certification programs
- Fixed $200 exam fee with LinkedIn-friendly digital badge
- Covers architecture, SQL, admin basics, backup concepts, HA options, and monitoring
Watch outs
- Multiple choice only; no live configuration or restore task
- Six-week window to sit after purchase
- Version-specific badge (v18, v16, or v14)
EDB Advanced for PostgreSQL
EDB (EnterpriseDB)
- Format
- Online multiple choice
- Duration
- 90 minutes (~60 questions)
- Price
- $200 USD
- Validity
- Digital badge (typically 2 years)
Best for: Experienced DBAs adding the senior EDB badge after Essentials, especially where HR filters on certification vendor.
Strengths
- Advanced scope: partitioning, replication, Patroni, PITR, EXPLAIN ANALYZE, RLS
- Clear step up from Essentials on the same exam platform
- Credible senior-level knowledge check for teams already standardized on EDB training
Watch outs
- Still multiple choice; no live failover or restore exercise
- Essentials-level knowledge expected first
- Heavy topic breadth for a 90-minute sitting
PostgreSQL Bootcamp (Udemy)
Udemy
- Format
- Self-paced video course + hands-on labs
- Duration
- ~60+ hours of content
- Price
- Often $15-20 on sale; list price higher
- Validity
- Certificate of completion (no expiry)
Best for: Self-study before a proctored or live lab exam, not as a substitute for one.
Strengths
- Covers SQL through PL/pgSQL, indexes, partitions, and window functions
- Low cost entry point with a shareable completion certificate
- Self-paced pacing fits nights-and-weekends study
Watch outs
- Not a proctored or live lab credential
- Quality varies across Udemy PostgreSQL courses
- Will not survive a screen built around timed server work
EDB Essentials for PostgreSQL training
EDB Training
- Format
- Instructor-led (4 days)
- Duration
- 4 days (versions 18, 16, or 14)
- Price
- Varies; contact EDB for quotes
- Validity
- Course completion; includes one complimentary Essentials exam attempt
Best for: Teams with a training budget that already standardize on EDB curriculum.
Strengths
- Official EDB curriculum aligned to the Essentials exam
- Instructor-led delivery with structured labs
- One Essentials exam attempt included per student
Watch outs
- Most expensive prep path on this list
- Class dates may not fit individual schedules
- Course completion alone is not the certification
When to sit EDB anyway
EDB remains a credible program. EDB contributes heavily to PostgreSQL and runs a structured Essentials → Advanced path that many employers already recognize. Keep EDB on your plan when the job posting, RFP, or internal catalog names “EDB Essentials” or “EDB Advanced” by name. Procurement and HR filters often match that string before anyone reads the exam format.
Essentials is also a reasonable first cert if you are new to PostgreSQL and want a fixed-price knowledge check before committing to a live lab sitting. Pair it with home lab practice, then sit DB-OPS-PSQL when you are ready to prove the operational side.
OSPI is an independent certification body and is not affiliated with, sponsored by, or endorsed by EDB, the PostgreSQL Global Development Group, or other vendors named in this article. PostgreSQL is a trademark of the PostgreSQL Global Development Group.
How to study for DB-OPS-PSQL
Study like you are taking over a production instance. Read the exam objectives first. Every task maps to commands you would run on a real server.
- Roles and databases: create login roles with connection limits, provision an application database, and document ownership. See the PostgreSQL role management docs.
- Schema and access: deploy provided DDL, add indexes for query patterns, grant least privilege, and set default privileges for future objects. See privileges and GRANT.
- Reporting: build views and aggregate queries that match stated business columns. Practice reading results from
psqloutput without GUI tools. - Configuration and auth: adjust logging parameters, edit
postgresql.conf, and configurepg_hba.conffor local TCP access. See pg_hba.conf. - Backup and restore: run
pg_dumpin custom and plain formats, restore into a separate database, and verify row counts. See logical backup. - Maintenance and WAL: run
VACUUM ANALYZE, readpg_stat_user_tables, tail the server log, and configure WAL archiving to a local directory. See routine maintenance and continuous archiving.
Use a local VM or cloud instance running PostgreSQL 16. Break things on purpose: revoke the wrong grant, misconfigure pg_hba, restore to the wrong database, then fix it without notes. Review candidate documentation for exam-day logistics, then enroll while the muscle memory is still fresh.
Using EDB or Udemy as prep
EDB Essentials study guides and Udemy courses can build vocabulary before a live lab attempt. They do not replace typing commands under a clock. If you already passed Essentials, treat DB-OPS-PSQL as the exam that closes the proof gap: configuration files, restores, and maintenance on a real host.
Block time on a Linux VM this week. Create two roles, restore a dump into a new database, and verify TCP connectivity. That is the work DB-OPS-PSQL grades.