Chapter 10. Running a PostgreSQL Database Server

In this chapter, we will cover the following recipes:

• Installing the PostgreSQL database server

• Locating the PostgreSQL server configuration files

• Allowing access to PostgreSQL over the network

• Accessing the PostgreSQL server over an SSH tunnel

• Creating a new database

• Creating users and granting permissions

• Creating a backup of your database

• Executing custom SQL commands

• Restoring a database from backup

• Editing the structure of your database

• Editing records in a database

• Installing phpPgAdmin