PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Kevin Grittner
Day Talks - second day - 2009-05-22
Room DMS 1160
Start time 11:30
Duration 01:00
ID 129
Event type Lecture
Track Case Studies
Language used for presentation English

Converting 100 databases to PostgreSQL

Wisconsin State Courts implementation

The Wisconsin State Courts converted their databases, physically located at 72 county circuit court sites, as well several central sites, to PostgreSQL in a very short time without major problems. All county servers were converted over the course of a few months.

Users, many of whom were very worried in advance, were surprised that they had no down time or disruption of their work. Many commented that the only change they noticed is that applications were "snappier" or "crisper". This session presents the environment in which this occurred, the preparation and planning involved, and the techniques used to roll out PostgreSQL to production. A major factor in the success of this effort was the amazing support of the PostgreSQL community through the PostgreSQL mailing lists.