Database Administration (PostgreSQL)

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

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