My AccidentalDBA tutorial materials have been updated for pgConfSV next week. If you are planning to take this tutorial, please read and follow the setup instructions before you get to the conference.
I created this tutorial in 2009 because of the number of people these days who find themselves in charge of a PostgreSQL server ... or many servers ... without any DBA background, training, or desire to be ops. The tutorial is intended to teach you the minimum you need to keep your PostgreSQL server from falling over so you can get back to whatever your main job is.
You can take it self-paced if you can't make it to pgConfSV. The tutorial includes all materials and notes. In this version, I've added the option of a Docker container (preferred), pg_stat_statements, and a restore-to-point-in-time exercise.
If you are going to attend this tutorial, note that it requires advance setup which will be harder to perform once you get to your hotel, and near-impossible if you wait until 10 minutes before it starts. So read up and install now.
And ... I believe there's still a few registrations left for the tutorial day, so consider signing up. You have nothing to lose but your fear of database admin!