Wiki: PostgreSQL

PostgreSQL Reloaded – Hot Standby, Streaming Replication & More!

Tuesday, July 20
8:30AM
E143/144

In this HANDS ON tutorial, you’ll learn how to design and deploy a wide range of backup and recovery techniques using PostgreSQL 9.0 Beta 3.

Although PostgreSQL 9.0 has not yet been released, the techniques covered in this tutorial leverage several cutting-edge features of PostgreSQL 9.0, so you’ll be learning techniques using the latest-and-greatest release of PostgreSQL!

As you can imagine, to design and test replication features with PostgreSQL you’ll need more than a single PostgreSQL instance – I’ll be using two CentOS virtual machines, and if you’d like to participate in the hands on portions of this tutorial, you should be sure to do the following:

- Download and install (using VMWare or VirtualBox) a linux virtual machine, and install PostgreSQL 9.0 beta 3 (or 2) on it. You can download RPM’s of PostgreSQL 9.0 beta 3 (or 2) from the URL below, and use the standard RPM installation method to install them (or you can install from source code):

http://www.postgresql.org/download/linux

If you prefer to use Windows, you can install two Windows virtual machines, but you’ll need to know how to automate the copying of files from one system to the other using Windows (not difficult, but this tutorial will be demonstrated on the Linux platform; though everything but shell scripts work about the same on Windows)

All that being said – don’t fret if you aren’t set for the hands-on portions of the tutorial – everything will be demonstrated during the lecture portion as well, and you’ll have plenty of opportunities to ask questions and learn more about designing and deploying highly available PostgreSQL Solutions.

  • Intel
  • Microsoft
  • Google
  • Facebook
  • Rackspace Hosting
  • (mt) Media Temple, Inc.
  • ActiveState
  • CommonPlaces
  • DB Relay
  • FireHost
  • GoDaddy
  • HP
  • HTSQL by Prometheus Research
  • Impetus Technologies Inc.
  • Infobright, Inc
  • JasperSoft
  • Kaltura
  • Marvell
  • Mashery
  • NorthScale, Inc.
  • Open Invention Network
  • OpSource
  • Oracle
  • Parallels
  • PayPal
  • Percona
  • Qualcomm Innovation Center, Inc.
  • Rhomobile
  • Schooner Information Technology
  • Silicon Mechanics
  • SourceGear
  • Symbian
  • VoltDB
  • WSO2
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON Newsletter (login required)

OSCON 2.0 Ideas

Have an idea for OSCON to share? oscon-idea@oreilly.com

Contact Us

View a complete list of OSCON contacts