Database Administration (PostgreSQL)

Install, secure, back up, tune and monitor PostgreSQL, and run migrations without downtime.

Fortgeschritten 8 Module ca. 14 Std. Kostenlos
Lernpfad starten
  1. 1 PostgreSQL Architecture and Installation How PostgreSQL is organised, installing it properly and connecting with psql. 30 Min.
  2. 2 Roles, Privileges and Security Least-privilege roles, default privileges, pg_hba rules, TLS and row-level security. 35 Min.
  3. 3 Backup and Restore Logical dumps, physical backups, point-in-time recovery and restore testing. 40 Min.
  4. 4 Performance: Indexes and Query Plans Read EXPLAIN ANALYZE, choose the right index and find the slow queries that matter. 40 Min.
  5. 5 Maintenance: VACUUM, Bloat and Statistics Why PostgreSQL needs vacuuming, tuning autovacuum and keeping statistics fresh. 30 Min.
  6. 6 Connections and Pooling Size connection pools, use PgBouncer and avoid exhausting max_connections. 30 Min.
  7. 7 Migrations Without Downtime Change schemas safely with Alembic, avoid long locks and use expand-and-contract. 35 Min.
  8. 8 Monitoring, Replication and High Availability Watch the right metrics, set up streaming replicas and plan for failover. 35 Min.