As part of an upcoming move off Heroku and onto Digital Ocean for a few of my products I want to make sure I’m more comfortable admining a few Postgres servers. I won’t be doing anything too complex I just want to be comfortable making sure back up and recovery is working properly/safely and maybe a bit of optimization. Once Digital Ocean releases their hosted Postgres instances to general availability I’ll probably switch over since managing a DB isn’t something I want to do forever but it will be a stop gap.

So my first book is one that is full of helpful tips to get me there.

PostgreSQL 10 Administration Cookbook