PostgreSQL Unboxing

Location: E145-146 Level: Novice
Tags: postgresql
Average rating: ****.
(4.25, 8 ratings)

In this one intense tutorial, we’ll go from a bare machine with just a PostgreSQL source tarball or RPM in hand to a fully-functional, replicated, backed-up, tuned database installation. We’ll cover:

  1. Installing the base PostgreSQL package and important additional modules.
  2. How to lay out the installation and the various components of PostgreSQL in the right places in the file system.
  3. Basic PostgreSQL tuning and optimization for particular hardware.
  4. Getting PostgreSQL streaming replication/hot standby set up.
  5. Doing backups.
  6. Monitoring and performance checking once your database is in production.
  7. Disaster planning and recovery.

Only basic system administration experience is required; if you can type commands into bash, you’re qualified.

Photo of Christophe Pettus

Christophe Pettus

PostgreSQL Experts, Inc.

Christophe Pettus has been developing using PostgreSQL since 1998. He consults on database design and application development through PostgreSQL Experts.

Comments on this page are now closed.


david Sheth
08/02/2012 7:44am PDT

He posted very similar slides on his website, at

Dan Catalano
07/17/2012 3:24am PDT

could you post your slides? I little too fast to follow without referring back to the presentation. Cheers.


For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or

View a complete list of OSCON contacts