Customized PostGIS image

This Dockerfile relies on official PostGIS Dockerfile, which itself relies on official library Postgres Dockerfile with a customized database initialization and custom Postgres configuration overriding.

Currently registered Cytomine script(s):

1. optionally interpolate the environment variable present in any file under /cm_configs with a filename suffix .sample and move all files to their respective directory (see below).

Currently registered Cytomine db scripts(s):

1. Cytomine-specific database initialization (ltree extension loading).

PostGIS-specific configuration

This image works off-the-shelf but, if additional configuration is required, one can supply one or several postgres configuration files to override the default configuration. These file should follow the naming convention DD-*.conf (e.g. 50-additional.conf) where DD is a two digits number between 01 and 99 defining the read order of the override configuration files. These files should be mounted in /cm_configs/etc/postgres/conf.d/.

The image also supports environment variables supported by the base Postgres image (see official documentation).

Backup

This image provides a backup script. It will create an archive containing a full pg_dump of the database.
The backup script runs every 24h. It can be further invoked from the host running the container:

docker exec postgis backup

It produces a compressed archive in a backup subdirectory of the exposed volume: /var/lib/postgresql/data/backup.

Restore

To restore the database from a backup, follow those steps:

1. In the volume folder /var/lib/postgresql/data/backup (or in the equivalent folder on your host if you mounted the volume), rename the backup archive you want to restore into restore.tar.gz:

/var/lib/postgresql/data/backup# cp cytomine_postgis_backup_Fri.tar.gz restore.tar.gz

2. Run the restore script from the host:

~# docker exec postgis restore