Bruce Momjian

Postgres Administration Presentations


Mastering PostgreSQL Administration

Duration: 3 hours, 4 hours with questions
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.

Securing PostgreSQL From External Attack

Duration: 30 minutes, 45 minutes with questions
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.

PostgreSQL Replication Solutions

Duration: 45 minutes, 75 minutes with questions
This talk is for people who need some kind of replication and want to learn more about the replication options available for PostgreSQL.  Replication is not a single technology but rather a group of needs and solutions that has to be tailored to each usage for optimal performance and functionality.  This talk outlines the major needs for replication and major solutions, including those currently implemented in PostgreSQL and those in development.

The Magic of Hot Streaming Replication

Duration: 30 minutes, 45 minutes with questions
This talk explores the much-anticipated Postgres 9.0 features of hot standby and streaming replication. It explains how these features work, how to configure them, and their current limitations. It includes a hands-on demonstration that can be done either by the instructor or by students.

Rapid Upgrades With Pg_Upgrade

Duration: 30 minutes, 45 minutes with questions
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.

The Foundations of Tls and Secure Digital Communication

Duration: 90 minutes, 110 minutes with questions
Tls/ssl forms the backbone of secure digital communication. This presentation covers the mathematics behind cryptography, the popular key exchange and encryption methods, and details about the tls protocol. There is also an extensive section about the creation and use of digital certificates for authentication, with examples from web servers and Postgres.