A database is only useful if the right people can reach it, the wrong people cannot, and the data survives when something goes wrong. This module covers the everyday work of running a PostgreSQL server safely and keeping it healthy.
You'll start with users and roles and how to give each one only the access it needs, then see how pg_hba.conf decides who is allowed to connect and how they must prove who they are. After that you'll learn to back up and restore a database with pg_dump and pg_restore, and how VACUUM and autovacuum keep tables tidy and fast over time.
With a secure, well-maintained server in place, you'll be ready for the final module, Replication & Scaling, where you learn how to keep copies of your data and grow beyond a single server.
A step-by-step tutorial on creating a user in PostgreSQL, the first step in controlling who can access your database and what they can do.
An introduction to the pg_hba.conf file, which plays a key role in PostgreSQL authentication and security by controlling who may connect.
Learn how to back up and restore PostgreSQL databases using pg_dump and pg_restore, so your data is safe if something goes wrong.
A deep dive into PostgreSQL's vacuum mechanisms, and how to tune your maintenance strategy so tables stay clean and queries stay fast.