Pdxpug labs

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Ideas for workshops)
Line 1: Line 1:
 
==Ideas for workshops==
 
==Ideas for workshops==
  
 +
* Replication
 +
** streaming rep
 +
** slony
 +
** bucardo
 
* Choosing a High Availability plan
 
* Choosing a High Availability plan
 
* Different ways to take backups
 
* Different ways to take backups
Line 16: Line 20:
 
* Try out PostgreSQL Studio
 
* Try out PostgreSQL Studio
 
* Try out pgbadger (bring your logs!)
 
* Try out pgbadger (bring your logs!)
 +
* pgbench
 +
* pgpool
 +
* pgbouncer

Revision as of 03:01, 28 February 2014

Ideas for workshops

  • Replication
    • streaming rep
    • slony
    • bucardo
  • 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!)
  • pgbench
  • pgpool
  • pgbouncer
Personal tools