User Tools

Site Tools

Table of Contents

PostgreSQL

PostgreSQL is our preferred database for most situations. It's very reliable and feature-rich. Some of its key features:

ACID compliant since its inception

ANSI SQL

Full text search

JSON and key-value stores

GIS extensions

Mac OS X 10.8 (Mountain Lion) came with PostgreSQL 9.1.4; be sure $PATH has /usr/local/bin before /usr/bin, or else you'll get the wrong version. Mac OS X 10.9 (Mavericks) does not come with PostgreSQL.