Chapter 1. Installing PostgreSQL

In this chapter, we will cover the installation process of PostgreSQL. You will learn how to install binary packages and see how PostgreSQL can be compiled from source. Compiling from source is especially important if you happen to be using platforms on which no binaries are available (for example, AIX, HPUX, and so on).

We will cover the following topics in this chapter:

  • Preparing your setup
  • Installing binary packages
  • Compiling PostgreSQL from source
  • Understanding the existing databases
  • Creating databases

You will see how easy it is to make PostgreSQL work in a couple of minutes.

Preparing your setup

Before we dig into the actual installation process and see how things can be put to work, it makes sense to talk a little ...

Get PostgreSQL Administration Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.