A Docker configuration for postgresql with postgis support.

Based on Docker official Postgres image with the following differences:

• adding postgis-2.1
• using Ubuntu 14.04 trusty instead of Debian Wheezy as base image,

Note: As for the official Postgres image, the installation script creates a default database (postgres) with user postgres (no password). It may still be possible to create an application specific user and database.

docker build -t mobula/postgresql github.com/mobula/docker-postgresql-postgis

docker run --name some-postgres -d mobula/postgresql

This image includes EXPOSE 5432 (the postgres port), so standard container linking will make it automatically available to the linked containers. The default postgres user and database are created in the entrypoint with initdb.

The postgres database is a default database meant for use by users, utilities and third party applications. postgresql.org/docs

docker run --name some-app --link some-postgres:postgres -d application-that-uses-postgres

docker run -it --link some-postgres:postgres --rm mobula/postgresql sh -c 'exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres'

docker run -it --rm --link pg_edncodev:db --volumes-from=pg_edncodev --entrypoint=/bin/bash mobula/postgresql -s

**IMPORTANT: ** The Dockerfile uses an ENTRYPOINT instead of CMD.

docker run --rm --link some_postgres:db busybox env

The following environment variables are exposed:

HOSTNAME=97d51c4b353e
LANG=en_US.utf8

PG_VERSION=9.3.5-1.pgdg70+1
PG_MAJOR=9.3
PGDATA=/var/lib/postgresql/data

DB_NAME=/naughty_morse/postgres
DB_PORT=tcp://172.17.0.4:5432
DB_PORT_5432_TCP_PROTO=tcp
DB_PORT_5432_TCP_ADDR=172.17.0.4
DB_PORT_5432_TCP_PORT=5432
DB_PORT_5432_TCP=tcp://172.17.0.4:5432

DB_ENV_LANG=en_US.utf8
DB_ENV_PG_MAJOR=9.3
DB_ENV_PG_VERSION=9.3.5-1.pgdg70+1
DB_ENV_PGDATA=/var/lib/postgresql/data

In order to enable postGIS, connect to the selected database (by default: postgres) and run the following command:

CREATE EXTENSION postgis;