nomad-pgsql-patroni

A simple container running Postgres and Patroni useful for dropping directly into a Hashicorp environment (Nomad + Consul + Vault)

It also comes pre-baked with some tools and extensions

Tools

Name	Version	Link
awscli	1.22.64	https://pypi.org/project/awscli/
WAL-G	2.0.1	https://github.com/wal-g/wal-g
Patroni	3.0.0	https://github.com/zalando/patroni
vaultenv	0.15.1	https://github.com/channable/vaultenv

Extensions

Name	Version	Link
Timescale	2.13.1	https://www.timescale.com
PostGIS	3.4.1	https://postgis.net
pg_cron	1.6	https://github.com/citusdata/pg_cron
pg_idkit	0.2.1	https://github.com/VADOSWARE/pg_idkit
pgRouting	3.6.1	https://pgrouting.org
postgres-json-schema	0.1.1	https://github.com/gavinwahl/postgres-json-schema
vector	0.5.1	https://github.com/ankane/pgvector

Still running an older Postgres version?

These branches are mostly supported containing older versions. If I get behind on a point release feel free to raise an issue 👍

Usage

job "postgres-16" {
  type = "service"
  datacenters = ["dc1"]

  group "group" {
    count = 1

    network {
      port api { to = 8080 }
      port pg { to = 5432 }
    }

    task "db" {
      driver = "docker"

      template {
        data = <<EOL
scope: postgres
name: pg-{{env "node.unique.name"}}
namespace: /nomad

restapi:
  listen: 0.0.0.0:{{env "NOMAD_PORT_api"}}
  connect_address: {{env "NOMAD_ADDR_api"}}

consul:
  host: localhost
  register_service: true

# bootstrap config
EOL

        destination = "/secrets/patroni.yml"
      }

      config {
        image = "ghcr.io/ccakes/nomad-pgsql-patroni:16.2-1.tsdb_gis"

        ports = ["api", "pg"]
      }

      resources {
        memory = 1024
      }
    }
  }
}

Testing

An example docker-compose file and patroni config is included to see this running.