PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Greg Dostatni |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2013-05-24 |
| Room | MRT 256 |
| Start time | 10:00 |
| Duration | 01:00 |
| Info | |
| 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