Administer a PostgreSQL database securely from end to end — manage roles and privileges, enforce row-level security, lock down connections through pg_hba.conf, and take dependable logical and physical backups. You will finish able to grant least privilege, protect data in transit, and restore a cluster to a chosen point in time.
Watch the free preview
Roles, login roles and group roles — free to watch, no account needed.
What you'll learn
- Administer a PostgreSQL database securely with roles, privileges and backups
- Grant least-privilege access using GRANT, REVOKE and default privileges
- Enforce per-row access control with row-level security policies
- Harden authentication and connections through pg_hba.conf and TLS
- Take and restore logical and physical backups, including point-in-time recovery
Syllabus
Roles and Privileges
Roles, login roles and group rolesFree preview
Granting and revoking privileges
Access Control in Depth
Ownership, schemas and default privileges
Row-level security in practice
Connection and Password Security
Authentication and pg_hba.conf
Passwords, encryption and TLS
Backup and Recovery
Logical backups with pg_dump and pg_restore
Physical backups and point-in-time recovery
Lab — 10 Exercises & Solutions
Exercises 1–5
Exercises 6–10