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
- Los Angeles Data Platform, August 21, 2024
- Percona Live, May 16, 2022
- Percona Live Europe Open Source Database Conference, November 5, 2018
- PostgresConf US, April 16, 2018
- PGConf Local: Philly, July 13, 2017
- PG Day Russia, July 6, 2016
- PGCon, May 15, 2012
- PostgreSQL Conference Europe, October 18, 2011
- PgEast, March 22, 2011
- PG East,March 28, 2010
- PG West, October 16, 2009
- PostgreSQL East, April 3, 2009
- Consegi, August 29, 2008
- Linux Forum, March 5, 2005
- Gnu/Linux Congress, September 18, 2003
- SRA, February 4, 2003
- O'Reilly Open Source Convention, July 22, 2002
- O'Reilly Open Source Convention, July 7-11, 2003
- Renmin University, February 25, 2003
- Fosdem, February 8-9, 2003
- Japan PostgreSQL User's Group, February 1, 2003
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
- PostgreSQL User Group NL, April 11, 2023
- DevOps Stage, September 24, 2021 (video)
- PostgresConf.CN & PGConf.Asia, November 20, 2020
- Hopla webinar, June 3, 2020 (video)
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
- Stockholm PostgreSQL User Group, February 18, 2021
- pgDay Israel, September 10, 2020 (video)
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
- Postgres TV, April 21, 2022 (video)
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
- Fosdem PGDay, February 3, 2023
- PGConf NYC, September 22, 2022(video)
- All Things Open, October 18, 2021
- PGDay Austria, September 17, 2021
- Percona Live Online, May 12, 2021
- Hopla webinar, June 3, 2020 (video)
- PGConf.Russia, February 6, 2018 (video English, Russian)
- Siberian State Aerospace University, February 9, 2016
- SouthEast LinuxFest, June 12, 2015 (video)
- Libre Software Meeting, July 10, 2013
- Scale, February 22, 2013 (video)
- PG Corridor Days NYC, April 2, 2012
- Congreso Internacional de Software Libre, May 28, 2011
- PGCon, May 19, 2011
- O'Reilly MySQL Conference & Expo, April 12, 2011
- Scale, February 25, 2011 (video)
- Philadelphia Area Linux User Group – West, February 15, 2010
- San Paulo, Brazil, October 22, 2009
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
- Philadelphia Area Linux Users' Group, March 19, 2012
- webinar, December 2, 2009 (video, registration required)
- Congreso Internacional de Software Libre, May 27, 2011
- New York PostgreSQL Meetup Group, April 20, 2010
- Philadelphia Area Linux User Group – North, January 12, 2010
- European O'Reilly Open Source Convention, October 19, 2005
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
- ConFoo, February 27, 2013
- PGDay Austin, March 28, 2012
- webinar, August 18, 2011
- International Free Software Forum, July 2, 2011
- Scale, February 26, 2011
- New York PostgreSQL Meetup Group, January 11, 2011
- Italian PostgreSQL Day, December 10, 2010
- HighLoad++ Conference, October 25, 2010
- OpenSQL Camp, October 17, 2010
- PG East,March 28, 2010
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
- Philly PostgreSQL User Group, October 15, 2014
- PostgreSQL User Group Ireland, October 1, 2013
- Scale, February 23, 2013 (video)
- PgEast, March 25, 2011
- PGDay Europe, December 7, 2010
- PgWest, November 4, 2010
- HighLoad++ Conference, October 25, 2010
- Jpug 10th Anniversary Conference, November 20, 2009
- PGCon Brazil, October 24, 2009
- PG West, October 17, 2009
- PgDay at the O'Reilly Open Source Convention, July 19, 2009 (video)
- PGCon, May 21, 2009 (video, start 27:00)