EDB PostgreSQL Associate Certification
The EDB PostgreSQL Associate Certification validates foundational PostgreSQL skills: the process and memory architecture, SQL and PostgreSQL data types, installation, configuration and routine administration, backup and recovery and security (roles, pg_hba.conf), and monitoring and maintenance tasks such as VACUUM.
Ready to sit the mock exam?
The timer starts as soon as you begin. You can flag questions, move freely between them, and review everything before submitting. No sign-in required — sign in afterwards to save the result to your history.
Start PGCA examSkills measured
PostgreSQL Architecture
20%The postmaster and backend processes, shared buffers and WAL, MVCC, the data directory layout, and transaction visibility.
SQL and Data Types
20%DDL and DML, joins, constraints, numeric, character, date/time, boolean, JSON/JSONB and array types, and sequences.
Administration and Configuration
25%Installation, postgresql.conf parameters, starting and stopping the cluster, tablespaces, and managing databases and extensions.
Backup, Recovery and Security
20%pg_dump and pg_basebackup, WAL archiving and PITR, roles and privileges, and host-based authentication with pg_hba.conf.
Monitoring and Maintenance
15%pg_stat views, the statistics collector, VACUUM and autovacuum, ANALYZE, bloat, and reindexing.