Tutorial Presented by Josh Berkus of PGExperts at PGConf Silicon Valley 2015
The Accidental DBA
So, you’ve inherited a PostgreSQL server. Congratulations? Thanks to Postgres’ popularity as the database for new applications, both open source and commercial, thousands of developers, system administrators and devops are finding themselves in charge of PostgreSQL servers with no idea what to do next. This tutorial will cover the essential care and feeding of a Postgres elephant so that you can get back to your real job. The tutorial will include the following core topics: Installation Updates and upgrades Backup System information Configuration Basic query troubleshooting Connection management Monitoring Replication basics Where to go for further help TUTORIAL REQUIREMENTS AND INSTRUCTIONS FOR ATTENDEES The Accidental DBA tutorial will involve hands-on exercises for the attendees to learn the basic techniques involved in PostgreSQL administration. In order to do this, each attendee will need to run a Vagrant virtual machine or Docker container on her/his laptop while at the tutorial. As such, I ask all of the attendees to do the following: Plan to bring your full-power developer laptop to the tutorial. Between August 20 and September 15, install the updated tutorial materials from the [Accidental DBA GitHub page](github.com/pgexperts/accidentalDBA). That page will say when it's been updated for PostgresOpen. No time will be given during the tutorial for download and configuration, nor any assistance with Vagrant or Docker. People may attend The Accidental DBA without participating in the hands-on exercises, but you will not get as much out of the tutorial as those who do participate.