travstats-db

travstats-db

Official

Docker app from Abrechen2's Repository

Overview

PostgreSQL 15 with the PostGIS 3.4 spatial extension — the database TravStats expects.

This template is pre-filled with the container name travstats-db and the database/user pair flights/flights so the default DATABASE_URL in the TravStats template matches without further editing. Change the password to a strong value (e.g. openssl rand -base64 32) and reuse it in TravStats.

Install order: this container first, then the TravStats template. The database is published on the Unraid host at port 5432 (adjustable below) so TravStats can reach it via host.docker.internal:5432 without needing a shared Docker network. Keep the port free of conflicts with other PostgreSQL containers you may already run.

Storage: the default Application Data path (/mnt/user/appdata/travstats-db) maps to PostgreSQL's data directory. The actual cluster lives in a pgdata/ subdirectory (see the PGDATA variable below) — this is the officially recommended layout from the postgres Docker image and avoids a well-known Unraid permission issue where chown from inside the container can't reach the FUSE-backed share root.

The initial cluster is created on first start and then kept in place on updates; deleting the pgdata/ subdirectory wipes the database, so point your backup tool at this folder.

Why PostGIS, not plain Postgres? TravStats uses PostGIS for airport and route geometry. Plain postgres:15 fails the first TravStats migration.

Troubleshooting — "FATAL: could not open file global/pg_filenode.map: Permission denied"

If you see this error in the container log and TravStats shows "Error querying the database" on its setup page, your pgdata/ directory was created under the wrong UID by a previous (broken) install. Fix:

  1. Stop both containers (TravStats, travstats-db).
  2. On the Unraid console: rm -rf /mnt/user/appdata/travstats-db/pgdata (or whichever Application Data path you chose).
  3. Start travstats-db — it now re-runs initdb with the correct UID (999, the Postgres user inside the image).
  4. Start TravStats — setup page should load without errors.

If the fresh start still fails on /mnt/user/..., switch the Application Data path to /mnt/cache/appdata/travstats-db (direct cache-pool mount, bypasses Unraid's FUSE layer) and repeat step 3. Requires a cache pool to be configured.

postgis/postgis

Build Status Join the chat at https://gitter.im/postgis/docker-postgis

⚠️ Breaking change (PostgreSQL 18+): Default VOLUME path changed to /var/lib/postgresql

The postgis/postgis image provides tags for running Postgres with PostGIS extensions installed. This image is based on the official postgres image and provides Debian and Alpine variants for PostGIS 3.5.x and 3.6.x that are compatible with PostgreSQL versions 14, 15, 16, 17 and 18. Additionally, image variants are provided for PostgreSQL 17 and 18, built with PostGIS (and its dependencies) from their respective master branches. These are tagged as 17-master and 18-master.

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

installed extensions initialized
postgis yes
postgis_topology yes
postgis_tiger_geocoder yes, for PostGIS < 3.7
postgis_raster no (available)
postgis_sfcgal no (available)
address_standardizer no (available)
address_standardizer_data_us no (available)

For PostGIS 3.5 and 3.6 images, address_standardizer and address_standardizer_data_us are available from the PostGIS package but are not initialized by default. For *-master images tracking PostGIS >= 3.7, address_standardizer is installed separately from https://github.com/postgis/address_standardizer, while postgis_tiger_geocoder is no longer provided by PostGIS.

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.

Versions (2026-06-19)

Supported architecture: amd64 (x86-64)

Recommended versions for new users are:

  • postgis/postgis:18-3.6
    • ⚠️ Uses VOLUME path /var/lib/postgresql (changed in PostgreSQL 18+)
  • postgis/postgis:17-3.5
    • Uses legacy VOLUME path /var/lib/postgresql/data

Debian based (recommended)

  • This Docker-PostGIS image has a cautious release cycle to guarantee high stability.
    • By "cautious", we mean it does not always have the latest versions of geos, proj, gdal, and sfcgal packages.
  • We use PostGIS, geos, proj, gdal, and sfcgal packages from the Debian repository.
    • In the Debian Bullseye repository (for PostgreSQL 14 to 17), the versions are:
      • geos=3.9
      • gdal=3.2
      • proj=7.2
      • sfcgal=1.3.9
    • In the Debian Trixie repository (for PostgreSQL 18+), the versions are:
      • geos=3.13
      • gdal=3.10
      • proj=9.6
      • sfcgal2=2.0
  • This version is easy to extend and has matured over time.
DockerHub image Dockerfile OS Postgres PostGIS
postgis/postgis:14-3.5 Dockerfile debian:bullseye 14 3.5.2
postgis/postgis:15-3.5 Dockerfile debian:bullseye 15 3.5.2
postgis/postgis:16-3.5 Dockerfile debian:bullseye 16 3.5.2
postgis/postgis:17-3.5 Dockerfile debian:bullseye 17 3.5.2
postgis/postgis:18-3.6 Dockerfile debian:trixie 18 3.6.4

Alpine based

  • The base operating system is Alpine Linux. It is designed to be small, simple, and secure, and it's based on musl libc.
  • In the Alpine 3.24 version, the package versions are:
    • geos=3.14.1
    • gdal=3.13.0
    • proj=9.8.1
    • sfcgal=2.2.0
  • PostGIS is compiled from source, making it a bit more challenging to extend.
DockerHub image Dockerfile OS Postgres PostGIS
postgis/postgis:14-3.5-alpine Dockerfile alpine:3.24 14 3.5.7
postgis/postgis:15-3.5-alpine Dockerfile alpine:3.24 15 3.5.7
postgis/postgis:16-3.5-alpine Dockerfile alpine:3.24 16 3.5.7
postgis/postgis:17-3.5-alpine Dockerfile alpine:3.24 17 3.5.7
postgis/postgis:17-3.6-alpine Dockerfile alpine:3.24 17 3.6.4
postgis/postgis:18-3.6-alpine Dockerfile alpine:3.24 18 3.6.4

Test images

  • We provide alpha, beta, release candidate (rc), and development (identified as ~master) versions.
  • For *-master images, the template is updated manually, which might lead to a delay of a few weeks sometimes.
  • Current PostGIS 3.7 development images use the up-to-date CGAL revision from the 6.1.x-branch.
  • Starting with PostGIS >= 3.7, PostGIS itself no longer includes the address_standardizer and postgis_tiger_geocoder extensions. The *-master images install address_standardizer separately from https://github.com/postgis/address_standardizer and run its upstream-style installcheck. See: https://lists.osgeo.org/pipermail/postgis-devel/2026-February/030730.html
  • They also install the h3 and h3_postgis extensions from the main branch of https://github.com/postgis/h3-pg; because this is a development branch, their extension version may appear as unreleased.
DockerHub image Dockerfile OS Postgres PostGIS
postgis/postgis:16-master Dockerfile debian:trixie 16 development: postgis, geos, proj, gdal
postgis/postgis:17-master Dockerfile debian:trixie 17 development: postgis, geos, proj, gdal
postgis/postgis:18-master Dockerfile debian:trixie 18 development: postgis, geos, proj, gdal
postgis/postgis:19beta1-3.6 Dockerfile debian:trixie 19beta1 3.6.4
postgis/postgis:19beta1-3.6-alpine Dockerfile alpine:3.24 19beta1 3.6.4
postgis/postgis:19beta1-master Dockerfile debian:trixie 19beta1 development: postgis, geos, proj, gdal

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 postgis/postgis

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

Once you have started a database container, you can then connect to the database either directly on the running container:

docker exec -ti some-postgis psql -U postgres

... or starting a new container to run as a client. In this case you can use a user-defined network to link both containers:

docker network create some-network

# Server container
docker run --name some-postgis --network some-network -e POSTGRES_PASSWORD=mysecretpassword -d postgis/postgis

# Client container
docker run -it --rm --network some-network postgis/postgis psql -h some-postgis -U postgres

Check the documentation on the postgres image and Docker networking for more details and alternatives on connecting different containers.

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

Supported Environment Variables

Since the docker-postgis repository is an extension of the official Docker PostgreSQL repository, all environment variables supported there are also supported here:

Read more in the docker-postgres README page

⚠️ PGDATA Volume Path Change

Starting from PostgreSQL 18, the default data directory (VOLUME) path has changed. This affects all corresponding postgis/postgis:18-* and newer images.

Summary of volume paths:

Image name Image tag range --volume path
postgis/postgis 18-* /var/lib/postgresql
postgis/postgis 14-*17-* /var/lib/postgresql/data

Please adjust your volume mounts for 18+ images. For more details, see the upstream change.

Initialize Only on Empty Data Directory

Docker-specific environment variables (for example, POSTGRES_DB, POSTGRES_USER, POSTGRES_PASSWORD) take effect only when the container is started with an empty data directory. Any pre-existing database will be left untouched on container startup.

If you need to re-initialize or change settings, make sure to remove or re-create the volume first.

libpq Environment Variables

Please note that Docker environment variables are different from those used by the libpq — C Library. These include: PGDATABASE, PGUSER, PGPASSWORD, and others used by client tools.

Troubleshooting tips

Troubleshooting can often be challenging. It's important to know that the docker-postgis repository is an extension of the official Docker PostgreSQL repository. Therefore, if you encounter any issues, it's worth testing whether the problem can be reproduced with the official PostgreSQL Docker images. If so, it's recommended to search for solutions based on this. The following websites are suggested:

If your problem is PostGIS related:

And if you don't have a postgres docker experience - read this blog post:

Security

It's crucial to be aware that in a cloud environment, with default settings, these images are vulnerable, and there's a high risk of cryptominer infection if the ports are left open. ( Read More )

  • Note that ports which are not bound to the host (i.e., -p 5432:5432 instead of -p 127.0.0.1:5432:5432) will be accessible from the outside. This also applies if you configured UFW to block this specific port, as Docker manages its own iptables rules. ( Read More )

io_uring

Every postgis/postgis:18-* image includes io_uring capabilities for asynchronous I/O. However, some container runtimes (for example, containerd) have disabled io_uring support in the past due to security concerns. If you wish to experiment with this feature, please do so at your own risk, and only after explicitly enabling io_uring in your seccomp profile.

Recommendations

  • You can add options for using SSL ( see postgres example )
    • -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
  • Or you can use SSH Tunnels with -p 127.0.0.1:5432:5432

Security scanner information

  • Please also scan the base postgres Docker image for potential security issues. If your security scanner reports vulnerabilities (CVEs), check the Docker Library FAQ — especially the section “Why does my security scanner show that an image has CVEs?” For more specific issues related to the Postgres Docker image, you can search using these links:

  • Optimizing Security Scans: It's advisable to focus on scanning and fixing issues that can be resolved. Use this command to scan for fixable issues only:

    • trivy image --ignore-unfixed postgis/postgis:18-3.6-alpine
    • trivy image --ignore-unfixed postgres:18-alpine For more details, you can read this article

Limitations on Updates

Unfortunately, we don't have control over updates to Debian and Alpine distributions or the upstream postgres image. Because of this, there might be some issues that we cannot fix right away. On the positive side, the postgis/postgis images are regenerated every Monday. This process is to ensure they include the latest changes and improvements. As a result, these images are consistently kept up-to-date.

Suggestions Welcome

We are always open to suggestions to enhance security. If you have any ideas, please let us know.

Known Issues / Errors

When you encounter errors due to PostGIS update OperationalError: could not access file "$libdir/postgis-X.X, run:

docker exec some-postgis update-postgis.sh

It will update to your newest PostGIS. Update is idempotent, so it won't hurt when you run it more than once. You will get a notification like:

Updating PostGIS extensions template_postgis to X.X.X
NOTICE:  version "X.X.X" of extension "postgis" is already installed
NOTICE:  version "X.X.X" of extension "postgis_topology" is already installed
NOTICE:  version "X.X.X" of extension "postgis_tiger_geocoder" is already installed
ALTER EXTENSION
Updating PostGIS extensions docker to X.X.X
NOTICE:  version "X.X.X" of extension "postgis" is already installed
NOTICE:  version "X.X.X" of extension "postgis_topology" is already installed
NOTICE:  version "X.X.X" of extension "postgis_tiger_geocoder" is already installed
ALTER EXTENSION

Contributor guideline

This Docker-PostGIS project is part of the PostGIS group and follows more flexible contributor rules.

  • Please take a moment to review the current issues, discussions, and pull requests before you start.
  • If you have a major change in mind, we kindly ask you to start a discussion about it first.
  • After making changes to the templates, please run the ./update.sh script.
  • The README.md must be written in plain and platform-compatible Markdown that renders correctly on both GitHub and Docker Hub.

Code of Conduct

Link to the code of conduct

Install travstats-db on Unraid in a few clicks.

Find travstats-db in Community Apps on your Unraid server, review the template, and click Install. Unraid handles the Docker app or plugin setup from the published template.

Open the Apps tab on your Unraid server Search Community Apps for travstats-db Review the template variables and paths Click Install

Requirements

Used together with the TravStats Community Apps template.

Download Statistics

286,694,721
Total Downloads
7,687,491
This Month
6,244,728
Avg / Month

Total Downloads Over Time

Loading chart...

Related apps

Explore more like this

Explore all

Details

Repository
postgis/postgis:15-3.4
Last Updated2026-06-20
First Seen2026-04-27

Runtime arguments

Network
bridge
Shell
sh
Privileged
false
Extra Params
--restart=unless-stopped

Template configuration

Application DataPathrw

Parent directory for the PostgreSQL data. The actual cluster is created as a `pgdata/` subfolder here (see PGDATA). One persistent mount, survives container updates. Back this path up with your regular appdata backup.

Target
/var/lib/postgresql/data
Default
/mnt/user/appdata/travstats-db
Value
/mnt/user/appdata/travstats-db
PGDATAVariable

Actual PostgreSQL data subdirectory inside the Application Data mount. Using a subfolder (instead of the bind-mount root) is the official postgres-image recommendation and avoids a common Unraid FUSE permission issue. Do not change unless you know what you're doing.

Default
/var/lib/postgresql/data/pgdata
Value
/var/lib/postgresql/data/pgdata
POSTGRES_DBVariable

Database name. TravStats default expects 'flights'.

Default
flights
Value
flights
POSTGRES_USERVariable

Database user. TravStats default expects 'flights'.

Default
flights
Value
flights
POSTGRES_PASSWORDVariable

Database password. Generate a strong one with `openssl rand -base64 32`, then paste the same value into the TravStats DATABASE_URL field.

Default
CHANGEME
Value
CHANGEME
Host PortPorttcp

Port on the Unraid host that PostgreSQL listens on. TravStats connects through host.docker.internal:this port. Change only if 5432 is already in use by another Postgres.

Target
5432
Default
5432
Value
5432
TZVariable

Container timezone. Keep UTC.

Default
UTC
Value
UTC