Data

Troubleshooting

Mac

FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 9.2, which is not compatible with this version 9.0.4.

rm -rf /usr/local/var/postgres && initdb /usr/local/var/postgres --locale=C -E UTF-8

Reference

Postgres

• PostgreSQL.org Tutorial

• postgresqltutorial.com > Getting Started

• postgresqltutorial.com > Sample Database

• psql command line tutorial and cheat sheet

• Beginner’s Guide to PostgreSQL

• PostgreSQL tutorial

• A Getting Started PostgreSQL Tutorial

Python

• Using PostgreSQL in Python

Tools

• Heroku Postgres

• ElephantSQL