This Docker image is a container with all latest PostgreSQL extensions needed to do serious GIS work. It is based on Ubuntu 14.04 and features :
It creates a pggis database with a pggis superuser (password pggis), with postgis, pgrouting and pointcloud extensions activated. It is therefore ready to eat data, and you can enjoy 2D vector and raster features, 3D support and functions, large point data volumes and analysis, topology support and all PostgreSQL native features.
This Docker is aimed at tests and development. Do not use it for production purposes. It lacks security and is not micro-service oriented as should a Docker stack be. Use at your own risk. You have been warned.
Make sure you have docker installed. On Ubuntu 14.04, Docker is named docker.io, replace the docker by docker.io in the following if needed. It is advised to use the latest available Docker version from official packages. See : https://blog.docker.com/2015/07/new-apt-and-yum-repos/
If you just want to run a container with this image, you do not need this repository as the image is available on docker hub as a Trusted Build. Just run the container and it will download the image if you do not already have it locally :
sudo docker run --rm -P --name pggis_test oslandia/pggis /sbin/my_initIf PostgreSQL server does not start and you see a lot of dots on the screen, see Known Problems below.
When you run the image to create a new container, a database is automatically created on startup, with all extensions activated. the database is named pggis and belongs to the pggis user, with pggis as a password.
Assuming you have the postgresql-client installed, you can use the host-mapped port to test as well. You need to use docker ps to find out what local host port the container is mapped to first:
$ sudo docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
75fec271dc5e oslandia/pggis:latest /usr/lib/postgresql/ 51 seconds ago Up 50 seconds 0.0.0.0:49154->5432/tcp pggis_test
$ psql -h localhost -p 49154 -d pggis -U pggis --passwordWhen the container runs, it first check its /data/restore path for sql files and backup files.
If there is any backup file present, it will create a new database (named as the file basename), activate all extensions, and restore the backup database.
If there is any SQL file present, it will similarly create a new database, activate extensions, and load the SQL file into the created database.
To enable this, you have to map the exposed /data volume to a host directory when running the image. You can do so using the -v option of docker run. This host directory should then have a restore subdirectory with the backups you want to restore.
Example follows, restoring two backups, one in custom format, another in SQL.
$ find /home/user/mydata/
/home/user/mydata/
/home/user/mydata/restore
/home/user/mydata/restore/restore_test.backup
/home/user/mydata/restore/restore_test2.sql
/home/user/mydata/otherstuff
...
$ docker run --rm -P --name pggis_test -v /home/user/mydata:/data oslandia/pggis /sbin/my_init
Now if you want to use this repository to build or modify the image, continue reading.
Git clone this repository to get the Dockerfile, and cd to it.
You can build the image with :
sudo docker build -t oslandia/pggis .Run the container with :
sudo docker run --rm -P --name pggis_test oslandia/pggis /sbin/my_initDo not hesitate to fork, send pull requests or fill issues on GitHub to enhance this image.
Contact Oslandia at infos+pggis@oslandia.com for any question or support.
When using Docker with AUFS, you can hit bug #783, and PostgreSQL server cannot be started due to permission problems. You will see dots appearing on the screen forever. There are at least three alternatives to workaround this bug :
Wait until the AUFS fix is released and taken into account in Docker ( not released yet as of feb. 2015 )
Remove containers and images related to this project and rebuild the image from scratch :
# WARNING : These lines will stop and delete all your containers and images
# Be more fine-grained if you have running other containers you want to keep !
sudo docker stop $(sudo docker ps -a -q)
sudo docker rm $(sudo docker ps -a -q)
sudo docker rmi $(sudo docker images -q)
sudo docker build -t oslandia/pggis .
sudo docker run --rm -P --name pggis_test oslandia/pggis /sbin/my_initsudo docker exec -ti pggis_test bash
mkdir /etc/ssl/private-copy; mv /etc/ssl/private/* /etc/ssl/private-copy/; rm -r /etc/ssl/private; mv /etc/ssl/private-copy /etc/ssl/private; chmod -R 0700 /etc/ssl/private; chown -R postgres /etc/ssl/privateMore complete documentation on Oslandia's blog post : http://www.oslandia.com/full-spatial-database-power-in-2-lines-en.html
Dockerfile reference : http://docs.docker.io/reference/builder/
PostgreSQL service example : http://docs.docker.io/examples/postgresql_service/