Technical requirements

At this point in the book, we have learned how to install PostgreSQL and how to configure users, but if you haven’t read the previous chapters, you can easily start following the next steps using a Docker image as described below.

Using the Docker image

If you want to follow the next steps without installing and configuring PostgreSQL, you can do so easily using the Docker image in the GitHub repository (details on how to set it up are covered in Chapter 1, Introduction to PostgreSQL). So, let’s start the standalone container as described in Chapter 1, Introduction to PostgreSQL, and then execute the following:

$ sudo docker exec -it standalone_learn_postgresql_1 /bin/bash

After executing this instruction, we will be inside the standalone_learn_postgresql_1 container in a root shell:

root@learn_postgresql:/#

Connecting the database

Even if we didn’t use a Docker container but used a native PostgreSQL installation...