Chapter 2 — Further Reading

References for installation, the tools, and reproducible environments. As always, optional — Chapter 3 doesn't require any of it. Tagged by learning path where one benefits most.

Official, authoritative (everyone)

  • PostgreSQL Downloads — https://www.postgresql.org/download/. The canonical install instructions for every platform, always current. When in doubt, start here.
  • PostgreSQL Docs: "Server Setup and Operation." What the server is, how to start/stop it, and where its data lives — useful context for the client/server model, and a preview of Chapter 38.
  • psql reference — https://www.postgresql.org/docs/current/app-psql.html. The complete list of meta-commands and options. Skim it once; bookmark it forever. The "Advanced features" section (variables, \watch, scripting) is worth revisiting later.

The tools (💻 Developer · 🏗️ DBA)

  • pgAdmin — https://www.pgadmin.org/. The official GUI. Good for visual browsing and for people who prefer clicking. Comes with the Windows installer.
  • DBeaver — https://dbeaver.io/. A popular free, cross-database GUI with a clean query editor and a nice ER-diagram viewer. Works with PostgreSQL and almost everything else.
  • Postgres.app — https://postgresapp.com/. The easiest macOS install: a self-contained app with a one-click server.

Reproducible environments (💻 Developer · 🏗️ DBA)

  • Docker Postgres image — https://hub.docker.com/_/postgres. The official image's documentation: environment variables (POSTGRES_PASSWORD, POSTGRES_DB), volumes for persistence, and init scripts. The basis of Case Study 1 and the instructor lab.
  • Docker Compose docs. For pinning a project's database version in a version-controlled file so the whole team — and CI — runs the same thing. A small investment that prevents a whole class of "works on my machine" bugs.

Going a little deeper (🔬 CS Student)

  • PostgreSQL Docs: "Part I — Tutorial." The official getting-started tutorial. It overlaps this chapter but adds detail and is a good second pass.
  • "A Tour of Postgres Internals" talks/articles. Once you're comfortable connecting, a high-level tour of what the server is doing makes Chapter 28 (Internals) far less mysterious. Search for a reputable recent talk.

Do, don't just read

  • Make \conninfo a habit. At the start of any session, confirm where you are. It will save you from the Case Study 2 mystery.
  • Try both psql and a GUI on the same mercado database. Seeing the identical data through two clients makes the client/server model concrete.
  • Pin your version. Decide which PostgreSQL version you'll use for the whole book (15, 16, or 17) and stick with it. Consistency beats novelty here.

Next: Chapter 3 — The Relational Model, where you learn the precise vocabulary behind every table you just queried.