EDB PostgreSQL Professional study guide
EDB PostgreSQL Professional · Work through your exam, one topic at a time.
The EDB PostgreSQL Professional credential is positioned as a vendor-aligned certification for database professionals who administer, tune, protect, and migrate PostgreSQL estates, including deployments on EDB's commercial platform. It suits working DBAs, platform and infrastructure engineers, and migration or data-engineering specialists who already run PostgreSQL in production and want independent, structured validation of that experience. The EDB PostgreSQL Professional study guide has 5 sections and about 1,697 words.
01PostgreSQL Core Database Administration
This domain tests day-to-day operation of a PostgreSQL or EDB Postgres Advanced Server cluster: configuration and process control, roles and privileges, storage layout, and routine maintenance. initdb builds the cluster in PGDATA; pg ctl start stop restart reload status controls it, or the systemd/pg ctlcluster wrapper on packaged installs.
367 words, about 2 min02PostgreSQL Performance Tuning and Query Optimization
This domain tests whether you can read a plan, explain a bad row estimate, choose an index type, and size memory and parallelism without guessing. EXPLAIN alone shows estimates; EXPLAIN (ANALYZE, BUFFERS) shows actual rows, loops, and shared buffer hits versus reads.
335 words, about 2 min03High Availability, Replication and Backup/Recovery
This domain tests the durability chain: WAL archiving, point-in-time recovery, streaming replication, replication slots, failover, and choosing the right backup tool. pg dump / pg dumpall are logical, consistent-snapshot exports; they cannot replay WAL.
332 words, about 2 min04Migration
This domain tests moving Oracle, SQL Server or MySQL workloads onto EDB Postgres AI Database / Advanced Server: assessment, tooling, datatype and semantic mapping, and cutover. Inventory tables, indexes, constraints, sequences, views, synonyms, triggers, packages, PL/SQL, scheduler jobs and external tables.
309 words, about 2 min05Security and EDB Postgres AI Platform Operations
This domain tests hardening (authentication, least privilege, row-level security, TLS) and operating the EDB Postgres AI Platform's monitoring and management layer alongside AI features such as vector search. pg hba.conf methods: scram-sha-256 (default since PostgreSQL 14, supports channel binding over TLS), legacy md5 , cert , peer / ident , ldap , gss .
354 words, about 2 min