PostgreSQL Unboxing

Christophe Pettus (PostgreSQL Experts, Inc.)
Data
Location: E145-146
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.

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.

Comments

David Sheth
08/02/2012 2:44pm PDT

He posted very similar slides on his website, at thebuild.com/presentations/...

Daniel Catalano
07/17/2012 10:24am PDT

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

Sponsors

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

View a complete list of OSCON contacts