Pdxpug labs

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
Line 3: Line 3:
 
* Replication
 
* Replication
 
** streaming rep
 
** streaming rep
 +
*** flowchart of all the different options & pieces parts
 +
*** try this: https://github.com/darkixion/pg_rep_test
 
** slony
 
** slony
 
** bucardo
 
** bucardo
Line 9: Line 11:
 
* Troubleshooting slow queries
 
* Troubleshooting slow queries
 
* Monitoring (this could easily be a series on its own)
 
* Monitoring (this could easily be a series on its own)
 +
** check_postgres
 +
** Try out pgbadger (bring your logs!)
 
* Disaster Recovery
 
* Disaster Recovery
* Oh no, somebody deleted pg_xlog
+
** Oh no, somebody deleted pg_xlog
* Transaction wraparound
+
** Transaction wraparound
 
* Postgres on zfs
 
* Postgres on zfs
 
* Postgres packet captures
 
* Postgres packet captures
Line 18: Line 22:
 
* Benchmarking changes to GUCs, e.g. maintenance_work_mem.
 
* Benchmarking changes to GUCs, e.g. maintenance_work_mem.
 
* Try out WAL-E
 
* Try out WAL-E
* Try out PostgreSQL Studio
+
* Admin tools
* Try out pgbadger (bring your logs!)
+
** PgAdminIII
 +
** PostgreSQL Studio
 
* pgbench
 
* pgbench
* pgpool
+
* Connection poolers:
* pgbouncer
+
** pgpool
 +
** pgbouncer

Revision as of 23:00, 28 February 2014

Ideas for workshops

  • Replication
  • Choosing a High Availability plan
  • Different ways to take backups
  • Troubleshooting slow queries
  • Monitoring (this could easily be a series on its own)
    • check_postgres
    • Try out pgbadger (bring your logs!)
  • 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
  • Admin tools
    • PgAdminIII
    • PostgreSQL Studio
  • pgbench
  • Connection poolers:
    • pgpool
    • pgbouncer
Personal tools