Installing PostgreSQL


We recommend you install PostgreSQL 9.2 and above. We currently run our continuous integration tests on PostgreSQL 9.2. The PostgreSQL downloads page has packages for most systems that set up everything for you.

sudo apt-get install postgresql

There are several good options:

We have had good experiences with and Macports.

Some of the recommended setting below may not apply to older versions of PostgreSQL.

Configuration file

Most of the configurations below are made by updating the file postgresql.conf, usually located in /etc/postgres/version-nr/main.

Required Configurations

Allow remote connections

listen_addresses ‘*’
port 5432