O'Reilly Open Source Convention - August 1-5, 2005 - Portland, Oregon
 Convention Coverage


Running PostgreSQL 8 on Windows
Lance Obermeyer, director of products, Pervasive Software

Track: Databases
Date: Thursday, August 4th, 2005
Time: 2:35pm - 3:20pm
Location: D136

The recently released PostgreSQL version 8 includes native support for the Microsoft Windows platform. While this greatly expands the possible deployments of PostgreSQL, it also adds uncertainty around best practices. This talk presents the basic performance characteristics for PostgreSQL on Windows. It covers administration items that are specific to Windows, such as networking and user management. Finally, it detaila how to run PostgreSQL on a two node Windows cluster.

This session begins by presenting basic performance characteristics of PostgreSQL on Windows, so that administrators will be able to project whether PostgreSQL on Windows will service their workloads. This includes performance as observed through ODBC as well as directly through libpq.

Though new to PostgreSQL, Windows has served as the deployment platform for production databases for many years. Administrators on these other databases have developed best practices around items like system setup, network configuration, and user management. Obermeyer discusses many of these in the context of PostgreSQL.

Microsoft Windows 2000/2003 Server Enterprise Edition operating systems include a technology for implementing high availability clusters. This technology, now called Server Clusters, is very popular for running simple two-node shared disk clusters, since they are easy to administer, require no esoteric hardware, and provide improved availability. Configuring a database, however, can be difficult, since there are dependencies beyond just the server process. This talk closes with a checklist for configuring PostgreSQL to run on a system of this form.

Download presentation file

Diamond Sponsors

Computer Associates International Inc., (CA)
Hewlett Packard
Sun Microsystems

Platinum Sponsors

Novell, Inc.

Gold Sponsors


Silver Sponsors

Black Duck Software
Covalent Technologies
GroundWork Open Source Solutions
Intel Corporation
Mergere, Inc.
Yahoo! Inc.
Zend Technologies, Inc.

Media Sponsors

boing boing
C/C++ Users Journal
DevtownStation News
Digital ID World
Enterprise Open Source Journal
Free Software Magazine
InsideMac Radio
Integration Developer News
Linux Journal
Open Enterprise Trends
Software Association of Oregon
Version Tracker
Wi-Fi Technology Forum
Women's Technology Cluster

In-Kind Sponsors

Dell Inc.
Griffin Technology
Harman Multimedia


OSCON 2005 Sponsor Opportunities — Email us at

Download the OSCON 05 Sponsor/Exhibitor Prospectus

OSCON 2005 Media Sponsor Opportunities — Call Margi Levin at 707-827-7184 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Conference News

Want to receive conference news? Sign up for our email newsletter.

O'Reilly Home | Privacy Policy

© 2005, O'Reilly Media, Inc.