Postgres Professional has translated its DBA2: Configuration and Monitoring of PostgreSQL 16 course into English. It’s a four-day course for PostgreSQL administrators who already have basic Unix experience and PostgreSQL knowledge comparable to DBA1. Basic PostgreSQL Administration. It focuses on practical aspects of PostgreSQL configuration, monitoring, and maintenance, helping DBAs understand how server internals affect everyday administration decisions.
The course covers key topics such as MVCC, isolation, row versions, vacuuming and autovacuuming, freezing, buffer cache, write-ahead logging, checkpoints, WAL tuning, object-level and row-level locks, locks in RAM, extensions, localization, and server upgrades.
After completing the course, students will be able to configure PostgreSQL parameters based on the server’s internal architecture, monitor the server and use feedback for iterative tuning, work with localization-related settings, manage extensions, and understand the basics of PostgreSQL upgrades.
The course materials include a student guide that explains how to set up the virtual machine and complete the practical tasks.
The course was translated into English by Elena Sharafutdinova. Special thanks to Ilya Bashtanov and Alexander Meleshko for their review and help in preparing the materials.
Explore the course DBA2: Configuration and Monitoring of PostgreSQL 16.
