Dockerfile PostGIS/PGRouting

Info

This Dockerfile creates a container running PostGIS 2.1 in PostgreSQL 9.3 and pgrouting 2.x

• expose port 5432
• initializes a database in /var/lib/postgresql/9.3/main
• superuser in the database: docker/docker

Install

• docker build -t postgis:2.1 . or docker build -t postgis:2.1 github.com/helmi03/docker-postgis.git
• docker run -d postgis:2.1

Usage

To connect to database, use docker inspect CONTAINER and grep IPAddress, e.g.

CONTAINER=$(sudo docker run -d -t helmi03/postgis)
CONTAINER_IP=$(sudo docker inspect $CONTAINER | grep IPAddress | awk '{ print $2 }' | tr -d ',"')
psql -h $CONTAINER_IP -p 5432 -U docker -W postgres

Persistance

You can mount the database directory as a volume to persist your data:

docker run -d -v $HOME/postgres_data:/var/lib/postgresql postgis:2.1

Makes sure first need to create source folder: mkdir -p ~HOME/postgres_data.

If you copy existing postgresql data, you need to set permission properly (chown/chgrp)

Meta

Build width docker version 0.7.0

References

• Docker trusted build: helmi03/docker-postgis
• stigi/dockerfile-postgresql
• Docker PostgreSQL Service