Step by step guide to becoming a modern PostgreSQL DBA
The intent of this guide is to give you an idea about the DBA landscape and to help guide your learning if you are confused. The roadmap is highly opinionated — neither, knowing everything listed in the roadmap, nor the order of items given in the roadmap is required to be followed in order to be a DBA.
Get basic understanding of Postgres key terms and basic RDBMS concepts.
Get practical skills of how to set up and run Postgres to get a working environment for further learning.
systemd(start, stop, restart, reload).
pg_ctl, or OS-specific tools (like
Get practical skills of how to create and manipulate database objects and how to execute queries using
Get understanding of the main aspects of how Postgres could be configured. Deep understanding of Postgres internals is not yet necessary here.
Get understanding about basic security concepts and common ways of how to deploy secure configurations.
Get practical skills of how to deploy, extend, maintain and support Postgres installations and 3rd-party Postgres ecosystem software.
Zabbix, other favourite monitoring solution
Get practical skills, learn automation tools and automate existing routine tasks.
Learn theory and get practical skills of how applications should work with Postgres
sqitch, language-specific tools
Here is important to continuously extend and develop existing knowledge about Postgres.
Get basic understanding about troubleshooting tools and get practical skills of how to detect and resolve problems.
pgcenter- personal recommendation
ebpf, core dumps
Get understanding and practical skills of how to optimize SQL queries.
Get deeper understanding of Postgres use cases and where Postgres is suitable and where is not.
Get involved to Postgres community and contribute to Postgres; be a useful member of Postgres, and the open source community; use personal experience to help other people.