PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Greg Dostatni
Day Talks - Day 2 - 2013-05-24
Room MRT 256
Start time 10:00
Duration 01:00
ID 567
Event type Lecture
Track Case Studies
Language used for presentation English

Postgresql in Education

Lessons learned from deploying Postgresql at University of Alberta

University of Alberta migrated their central Learning Management System from Blackboard Vista on Oracle to Moodle on Postgresql 9.0 running inside VMWare cluster. We went from a pilot project of 13 courses in January 2011 to running all centrally supported courses (3600+) in Moodle in September 2012. Our central Moodle instance has seen more than 500,000 page loads and over 24,000 unique visitors in a single day. Since then we deployed Postgresql in a number of mission critical applications including our ticketing system and Enterprise Document Management system.

Over the last two years we have learned a few hard lessons and overcome a few challenges involved in running Postgresql in a 24x7 production environment, although the experience has been predominantly a positive one. We would like to share our experiences (as well as code and documentation) that will help other shops setup their first mission critical Postgresql installation.

Specific topics covered:

  • Configuring postgresql for production workload
  • What to monitor and when to act on it
  • Backups, cloning and recovery - omnipitr is your friend
  • Scalability
  • Upgrade paths and strategies
  • Replicating your production load against your data