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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.