PGCon is the place to meet, learn valuable insights and generally chat about the work being done with PostgreSQL, and it's shaping up to be the Postgres conference of the year. OmniTI is proud to be involved again this year, with perennial speaker Robert Treat doing two presentations, and this year he will be joined by Phillip Sorber, a Postgres contributor and DBA at OmniTI.
Treat will co-present a tutorial, Mastering PostgreSQL Administration, with Bruce Momjian, co-founder of the PostgreSQL Global Development Group. In this two-part course, attendees will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups and recovery. The course is designed for people with experience in database administration, but who are new to the Postgres platform.
In addition, attendees will hear Treat's Big Bad "Upgraded" PostgreSQL talk, covering several tools and tactics used at OmnITI to bring a large pg_upgrade project to completion, including all the different ways that things went wrong. Treat will discuss some of the changes seen after the upgrade, and improvements made using new, 9.1 features. According to Treat,
If you are using Postgres for mission-critical applications, you'll enjoy this look inside the operations of a complex system that lives on the edge.
OmniTI's Phillip Sorber is presenting a tutorial playfully titled, "Getting Hot and Streamy with Postgres: Using Postgres' Built-in Replication Facilities." This will be an overview of Postgres' built-in replication system, from PITR to cascading replication, complete with demonstrations. More emphasis will be given to the more recent and interesting technologies, such as streaming replication and hot standby. Sorber said,
My goal is that someone attending this tutorial would be able to understand enough about how replication works in Postgres to implement and maintain it going forward,
For more information about the conference, see PGCon.org.