SlaveCode
.
Academy
DSA
Resources
System Design
More
Toggle theme (Current: Custom)
PostgreSQL DBA Roadmap | SlaveCode
PostgreSQL DBA
Step by step guide to becoming a modern PostgreSQL DB Administrator in 2026
Back
Roadmap
Vedios and Other Resources
Projects
AI Tutor
PostgreSQL
Managing Postgres
DDL Queries
DML Queries
Advanced Topics
Connection Pooling
Replication
Anonymization
Upgrade Procedures
Cluster Management
Kubernetes Deployment
Monitoring
Load Balancing / Discovery
3rd Party
Builtin Tools
Configuration Management
Migrations
Queues
Data and Processing
Low Level Internals
Workload-Dependant Tuning
Operating System Tools
Profiling Tools
Log Analysis
Posgres System Views
Posgres Tools
Query Analysis
Techniques
Fine-grained Tuning
Following postgres.conf configuration
Backup & Recovery Tools
Application Skills
Advanced Topics
Advanced SQL
Troubleshooting Techniques
SQL Optimization Techniques
Visit the following relevant roadmaps
MongoDB
Backend
DevOps Roadmap
Related Roadmaps
MongoDB Roadmap
Backend Roadmap
Introduction
What are Relational Databases?
RDBMS Benefits and Limitations
PostgreSQL vs Other RDBMS
PostgreSQL vs NoSQL Databases
Basic RDBMS Concepts
Object Model
Queries
Data Types
Rows
Columns
Tables
Schemas
Databases
Relational Model
Domains
Attributes
Tuples
Relations
Constraints
NULL
High Level Database Concepts
ACID
MVCC
Transactions
Write-ahead Log
Query Processing
Using Docker
Package Managers
Connect using `psql`
Deployment in Cloud
Using `systemd`
Using `pg_ctl`
Using `pg_ctlcluster`
Installation and Setup
Learn SQL
For Schemas
ForTables
Data Types
Querying Data
Filtering Data
Modifying Data
Joining Tables
Import / Export Using `COPY`
Transactions
Subqueries
Grouping
CTE
Lateral Join
Set Operations
Configuring
Resource Usage
Write-ahead Log
Vacuums
Replication
Query Planner
Checkpoints / Background Writer
Reporting Logging & Statistics
Adding Extra Extensions
Security
Object Privileges
Grant / Revoke
Default Privileges
Advanced Topics
Row-Level Security
SELinux
Authentication Models
Roles
pg_hba.conf
SSL Settings
Infrastructure Skills
Using `pg_upgrade`
Using Logical Replication
Simple Stateful Setup
Helm
Operators
PostgreSQL Anonymizer
HAProxy
Consul
KeepAlived
Etcd
Prometheus
Zabbix
check_pgactivity
temBoard
check_pgbackrest
barman
WAL-G
pgbackrest
pg_probackup
pg_dump
pg_dumpall
pg_restore
pg_basebackup
Backup Validation Procedures
PgBouncer
PgBouncer Alternatives
Logical Replication
Streaming Replication
Patroni
Patroni Alternatives
Resource Usage / Provisioning / Capacity Planning
Learn to Automate
Shell Scripts
Any Programming Language
Ansible
Salt
Chef
Puppet
Practical Patterns / Antipatterns
Migration Related Tools
Bulk Loading / Processing Data
Data Partitioning
Sharding Patterns
Normalization / Normal Forms
Patterns / Antipatterns
PgQ
Processes & Memory Architecture
Vacuum Processing
Buffer Management
Lock Management
Physical Storage and File Layout
System Catalog
Per-User, Per-Database Setting
Storage Parameters
OLTP
OLAP
HTAP
PL/pgSQL
Procedures and Functions
Triggers
Recursive CTE
Aggregate and Window functions
top
sysstat
iotop
gdb
strace
ebpf
perf-tools
Core Dumps
pgBadger
pgCluu
awk
grep
sed
pg_stat_activity
pg_stat_statements
pgcenter
EXPLAIN
Depesz
PEV2
Tensor
explain.dalibo.com
USE
RED
Golden Signals
Schema Design Patterns / Anti-patterns
SQL Query Patterns / Anti-patterns
Indexes and their Usecases
B-Tree
Hash
GiST
SP-GiST
GIN
BRIN
Get Involved in Development
Mailing Lists
Reviewing Patches
Writing Patches