All apps · 0 apps

geometrikks-timescaledb

Overview

TimescaleDB (PostgreSQL + TimescaleDB + PostGIS) database for GeoMetrikks. Install this container first, set a POSTGRES_PASSWORD below, then install the "geometrikks" app template and use the same password there. This container has no web UI - it exists purely as the GeoMetrikks database backend.

Readme

View on GitHub

GeoMetrikks Unraid Templates

Unraid Community Apps templates for GeoMetrikks - a real-time geolocation analytics tool that tails nginx access logs, does GeoIP lookups, and visualizes traffic on a live interactive map.

This repository ships two Docker templates:

Template	What it is
`geometrikks-timescaledb`	TimescaleDB + PostGIS database - install this first
`geometrikks`	The GeoMetrikks app and web UI

Setup

1. Install the database

Add geometrikks-timescaledb from Community Apps. Set a POSTGRES_PASSWORD - you'll reuse this exact value in step 2. Leave POSTGRES_USER (geouser) and POSTGRES_DB (geometrikks) at their defaults unless you have a reason to change them.

The DB Port config (default 5432) is exposed to your LAN so the app container can reach it.

2. Install the app

Add geometrikks from Community Apps and fill in:

DB_HOST - your Unraid server's IP address (e.g. 192.168.1.50)
DB_PASSWORD - the same password you set for geometrikks-timescaledb in step 1
APP_ADMIN_USER / APP_ADMIN_PASSWORD - your web UI login or APP_AUTH_DISABLED=true
Nginx Logs path - point this at wherever your reverse proxy writes its access logs (defaults to a SWAG-style path; change it for Nginx Proxy Manager, Caddy, or whatever you actually run)

Leave DB_PORT/DB_USER/DB_DATABASE at their defaults unless you changed the matching values in step 1.

3. Get a free MaxMind GeoLite2 key

GeoMetrikks needs MaxMind's free GeoLite2 database for GeoIP lookups:

Sign up at https://www.maxmind.com/en/geolite2/signup
Create a license key under your account
Set MAXMINDDB_USER_ID and MAXMINDDB_LICENSE_KEY on the geometrikks template

Without these, GeoMetrikks runs in degraded mode (no GeoIP lookups) until you add them.

4. Open the web UI

http://<your-unraid-ip>:8000/ - log in with the admin credentials you set in step 2.

Notes

Full environment variable reference: https://github.com/GilbN/geometrikks/blob/main/docs/configuration.md. Most of it is exposed as "advanced" settings on the geometrikks template - expand "Show more settings" when adding the container to see database pool tuning, log parser tuning, analytics retention, and map settings.
GeoMetrikks itself: https://github.com/GilbN/geometrikks

Install geometrikks-timescaledb on Unraid in a few clicks.

Find geometrikks-timescaledb 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 geometrikks-timescaledb Review the template variables and paths Click Install

Explore Unraid OS

Requirements

Must be reachable from the geometrikks app container. This template exposes port 5432 to the host/LAN so the app container (run separately) can reach it via the Unraid server's IP address. Runs as fixed UID/GID 1000 the whole time (no root phase to self-fix permissions, unlike most Postgres images) - pre-create the Appdata folder and chown it to 1000:1000 before first start, and do not run Unraid's "New Permissions" tool against it afterward, or Postgres will fail to start.

Related apps

Explore more like this

Explore all

Management apps

Links

Projectgithub.com Supportgithub.com Docker Hubhub.docker.com Templateraw.githubusercontent.com

Details

Repository

timescale/timescaledb-ha:pg18

Registry

https://hub.docker.com/r/timescale/timescaledb-ha

Last Updated2026-06-23

First Seen2025-04-20

Runtime arguments

Network: bridge
Shell: sh
Privileged: false
Extra Params: --restart=unless-stopped --shm-size=512m

Template configuration

DB PortPorttcp

PostgreSQL port. Exposed to the host/LAN so the geometrikks app container can connect using the Unraid server's IP.

Target: 5432
Default: 5432

AppdataPathrw

Database data directory. bPerformance tip:/b For best performance, use a path that bypasses the Unraid array (e.g. /mnt/cache/appdata or /mnt/appdata if configured). Paths under /mnt/user go through a FUSE layer that significantly slows database operations.

Target: /home/postgres/pgdata/data

POSTGRES_PASSWORDVariable

Database password. Must match the DB_PASSWORD value you set in the geometrikks app template.

POSTGRES_USERVariable

Database user. Must match DB_USER in the geometrikks app template - only change if you also change it there.

Default: geouser

POSTGRES_DBVariable

Database name. Must match DB_DATABASE in the geometrikks app template - only change if you also change it there.

Default: geometrikks

Library

Curated

Categories