Table Of Contents

Previous topic

PostgreSQL

Next topic

Tomcat

This Page

Installing PostgreSQL

Important

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.

Fedora/CentOS
http://wiki.openscg.com/index.php/PostgreSQL_RPM_Installation
Debian/Ubuntu
sudo apt-get install postgresql
Mac

There are several good options:

We have had good experiences with Postgres.app 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 updating the file postgresql.conf, usually located in /etc/postgres/version-nr/main.

Required Configurations

Allow remote connections

listen_addresses ‘*’
port 5432