winter227/postgis repository overview

⁠winter227/postgis

The winter/postgis image provides a Docker container running Postgres with PostGIS 3.1.1 installed. This image is based on the official postgres image.

This image ensures that the default database created by the parent postgres image will have the following extensions installed:

• postgis

• postgis_topology

• fuzzystrmatch

• postgis_tiger_geocoder

Unless -e POSTGRES_DB is passed to the container at startup time, this database will be named after the admin user (either postgres or the user specified with -e POSTGRES_USER). If you would prefer to use the older template database mechanism for enabling PostGIS, the image also provides a PostGIS-enabled template database called template_postgis.

⁠Usage

In order to run a basic container capable of serving a PostGIS-enabled database, start a container as follows:

docker run --name some-postgis -e POSTGRES_PASSWORD=mysecretpassword -d winter227/postgis

or

docker run --name postgis --restart=unless-stopped  -v  /data/postgis:/var/lib/postgresql/data -e POSTGRES_PASSWORD=123456 -p 5432:5432 -d winter227/postgis

For more detailed instructions about how to start and control your Postgres container, see the documentation for the postgres image here.

Once you have started a database container, you can then connect to the database as follows:

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

See the PostGIS documentation⁠ for more details on your options for creating and using a spatially-enabled database.

⁠Dockerfile

#FROM mdillon/postgis:11

FROM postgres:11.2

MAINTAINER Late_Winter

RUN apt-get update

#RUN apt-get -y remove postgresql-11-postgis-2.5 postgresql-11-postgis-2.5-scripts

RUN apt-get -y install postgresql-11-postgis-3 postgresql-11-postgis-3-dbgsym postgresql-11-postgis-3-scripts postgresql-11-pgrouting-scripts

RUN apt -y install postgresql-11-pgrouting

ADD postgis.sh /docker-entrypoint-initdb.d/postgis.sh

RUN chmod -R 777 /docker-entrypoint-initdb.d/postgis.sh

RUN chmod +x /docker-entrypoint-initdb.d/postgis.sh

EXPOSE 5432

#CMD ["docker-entrypoint.sh","postgres"]

⁠postgis.sh

#!/bin/sh set -e

echo "user name = ${USER}"

id

pwd

export PGUSER="$POSTGRES_USER"

psql -c "CREATE DATABASE template_postgis"

psql -c "UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis'"

psql template_postgis -c "CREATE EXTENSION IF NOT EXISTS postgis"

psql template_postgis -c "CREATE EXTENSION IF NOT EXISTS postgis_topology"

psql template_postgis -c "CREATE EXTENSION IF NOT EXISTS pgrouting"

psql template_postgis -c "CREATE EXTENSION IF NOT EXISTS fuzzystrmatch"

psql template_postgis -c "CREATE EXTENSION IF NOT EXISTS postgis_tiger_geocoder;"