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

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

Databases, Containers, and the Cloud

Containers and the cloud are all the rage as companies seek new efficiencies and flexibility. While they are very popular, database use of these facilities is still growing. This talk explores their benefit for database deployments.
Duration: 30 minutes, 45 minutes with questions

Postgres in the Cloud: The Hard Way

There are many ways to easily install Postgres in the cloud, using guis, software packages, containers, and orchestration software. This presentation uses none of those — rather it installs Postgres in aws strictly from the command line. This allows you to see exactly what is happening, and how it all fits together.
Duration: 30 minutes, 45 minutes with questions

Postgres in the Microservices World

Microservice architectures require new information technology approaches in enterprises; the changes include team restructuring, deployment granularity, and even technology. This presentation explains the benefits of microservice architectures and the challenges it poses for relational databases like Postgres. It will explain how Postgres can be used to implement microservices while minimizing the downsides of segregating data in microservices.
Duration: 90 minutes, 2 hours 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

Cluster File Encryption in Postgres

Cluster file encryption, or Transparent Data Encryption (tde) as it is called in the industry, is the ability of the database to store all user data encrypted in the file system. It prevents users with read access on the database directories from being able to access the data stored in those files, and provides data-at-rest security. This talk explains the general features of cluster file encryption and how it will be implemented soon in Postgres.

PostgreSQL Replication Solutions

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

The Magic of Hot Streaming Replication

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.
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