# PostgreSQL Database Administration Assessment

## Description
The PostgreSQL Database Administration assessment is designed to measure candidates' and employees' knowledge and skills required to support PostgreSQL database configuration, maintenance, and operations, covering areas such as Database Object Creation and Management, User, Role, and Access Control Management, Backup and Recovery, Performance Monitoring and Query Optimization, Routine Maintenance (VACUUM and ANALYZE), and PostgreSQL Configuration and Instance Management. The test evaluates skills related to installation, initialization, and configuration of PostgreSQL instances, including modification of postgresql.conf and pg_hba.conf parameters, as well as the creation and management of databases, schemas, tables, indexes, and views using SQL and PostgreSQL utilities. It also assesses knowledge of user and role management, authentication, privileges, access control, backup and recovery procedures using pg_dump, pg_restore, and continuous archiving with write-ahead logs, and performance monitoring using system catalog tables, statistics views, and the EXPLAIN command. Additional topics include VACUUM and ANALYZE operations, tablespace management, streaming and logical replication, transaction management, concurrency control, lock monitoring, logging configuration, log analysis, instance upgrades using pg_upgrade, and connection management and pooling. The test presents a mix of Multiple Choice, Multiple Correct Answer, and Essay Composition questions, with questions drawn from a large pool to minimize the risk of cheating. One or more questions are subject to individual time limits to further deter cheating and to enhance the predictive value of the assessment, and one or more questions are scored using artificial intelligence to ensure accurate and consistent evaluation of candidate responses.

## Competencies Measures
- Backup and Recovery
- Database Object Creation and Management
- Database Object Creation and Management (Free Text Responses)
- Performance Monitoring and Query Optimization
- PostgreSQL Configuration and Instance Management
- Routine Maintenance (VACUUM and ANALYZE)
- User, Role, and Access Control Management
- User, Role, and Access Control Management (Free Text Responses)

## Metadata
- **Duration:** 19.0 Minutes
- **Language:** English (US)
- **Type:** Skills/Knowledge Assessment (Test)
- **Last Updated:** July 1, 2026

## Catalog Link
View additional details or to administer the assessment to a candidate here:
[View in Online Test Catalog](https://www.hravatar.com/ta/tests/9670/postgresql-database-administration.html)