PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Kevin Grittner |
| Schedule | |
|---|---|
| Day | Talks - second day - 2009-05-22 |
| Room | DMS 1160 |
| Start time | 11:30 |
| Duration | 01:00 |
| Info | |
| 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.