High Performance PostgreSQL for Rails

Chapter 2Administration Basics

In this chapter, you’ll begin performing administration tasks to grow your operational knowledge with PostgreSQL.

In the last chapter, you installed and configured the Rideshare Rails app connected to a PostgreSQL database. If you skipped the introduction and aren’t familiar with Rideshare, consider going back and setting it up before proceeding since you’ll be using the database for exercises.

You’ll use new terminology like meta-commands, the psql client, observability in PostgreSQL, locks, database parameters, and extensions.

Let’s get started.