⇽ Bruce Momjian ⇽

Postgres Administration Presentations


Mastering PostgreSQL Administration

This talk is designed for PostgreSQL administrators.  It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery.  It shows how to control host connectivity, configure the server, find the query being run by each session, and find the disk space used by each database.
Duration: 3 hours, 4 hours with questions

The Wonderful World of WAL (no slides yet)

The Postgres write-ahead log, or WAL, is basically a change-log for the database. It enables several important Postgres features: crash recovery, point-in-time recovery, and binary and logical replication. This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress.
Duration: 45 minutes, 60 minutes with questions

User, User, Who Is the User?

Postgres allows multiple users to interact with minimal conflict. By defining roles for users and groups of users, multi-user management is greatly simplified. This talk covers database roles, role membership, role inheritance, object access control, and predefined roles. It shows how such features streamline the management and security of complex database systems.
Duration: 45 minutes, 60 minutes with questions

Securing PostgreSQL From External Attack

This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. This talk covers all known Postgres external attack methods.
Duration: 30 minutes, 45 minutes with questions

Rapid Upgrades With Pg_Upgrade

Pg_Upgrade allows data to be transferred between major Postgres versions without a dump/restore. It does this by transferring the user data and version-dependent data separately. This talk explains the internal workings of pg_upgrade and includes a pg_upgrade demonstration.
Duration: 30 minutes, 45 minutes with questions