Pdxpug labs

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(ideas for pddxpug lab days. If this takes off, I'll link it back to the main pdxpug page.)
 
(Ideas for workshops)
Line 15: Line 15:
 
* Try out WAL-E
 
* Try out WAL-E
 
* Try out PostgreSQL Studio
 
* Try out PostgreSQL Studio
 +
* Try out pgbadger (bring your logs!)

Revision as of 00:28, 27 February 2014

Ideas for workshops

  • Choosing a High Availability plan
  • Different ways to take backups
  • Troubleshooting slow queries
  • Monitoring (this could easily be a series on its own)
  • Disaster Recovery
  • Oh no, somebody deleted pg_xlog
  • Transaction wraparound
  • Postgres on zfs
  • Postgres packet captures
  • Tour of contrib modules
  • Foreign Data Wrappers
  • Benchmarking changes to GUCs, e.g. maintenance_work_mem.
  • Try out WAL-E
  • Try out PostgreSQL Studio
  • Try out pgbadger (bring your logs!)
Personal tools