Administering PostgreSQL
Keeping a real, running database alive — installation, users, backups, restores, replication, and the tuning that keeps it fast under load.
What you'll actually learn
Running PostgreSQL past a first CREATE TABLE means owning things a tutorial never covers: real user and permission management, backups that actually restore when tested (not just taken), replication that keeps a second copy honestly in sync, and the tuning work that keeps queries fast once real load shows up. This track builds all of it on a genuinely running database, not a diagram of one.
What you'll be able to do
You'll set up backups, deliberately break the database, and restore it from what you built — the exact sequence a real outage demands, done once on purpose so it isn't the first time you do it under pressure. That rehearsal is the actual job of a database administrator, and it's the part that separates "I've used Postgres" from "I keep Postgres alive."
Syllabus
Leads to
Frequently asked
Roughly 2 hours across 9 hands-on quests — you can go at your own pace and pick up exactly where you left off.
You should be comfortable with SQL in Practice, Linux Administration first — the skill tree unlocks Administering PostgreSQL once you've cleared those.
Yes — Administering PostgreSQL is fully available on the free tier, starting with a free first quest and no payment method required to sign up. Plus and Elite remove pacing limits but don't gate any of the Administering PostgreSQL curriculum behind a paywall.
Create a free account and begin your first quest — no card required.
Start free