sycured/nomad-pgsql-patroni

Simple container for running Postgres HA on Nomad

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	Link	Type of install
Patroni	https://github.com/zalando/patroni	Package
Pg_Timetable	https://github.com/cybertec-postgresql/pg_timetable	Package
WAL-G	https://github.com/wal-g/wal-g	Binary

Extensions

Name	Link	Type of install
citus	https://github.com/citusdata/citus	Package
hyperloglog	https://github.com/citusdata/postgresql-hll	Package
hypopg	https://github.com/HypoPG/hypopg	Package
pg_cron	https://github.com/citusdata/pg_cron	Package
pg_qualstats	https://github.com/powa-team/pg_qualstats	Package
pg_stat_kcache	https://github.com/powa-team/pg_stat_kcache	Package
pgrouting	https://pgrouting.org	Package
pgsodium	https://github.com/michelp/pgsodium	Build
postgis	https://postgis.net	Package
postgres-json-schema	https://github.com/gavinwahl/postgres-json-schema	Build
powa	https://github.com/powa-team/powa	Package
tdigest	https://github.com/tvondra/tdigest	Package
topn	https://github.com/citusdata/postgresql-topn	Package
vector	https://github.com/ankane/pgvector	Build

Enable hypopg

CREATE EXTENSION hypopg;

Enable powa

CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION btree_gist;
CREATE EXTENSION powa;
CREATE EXTENSION pg_qualstats;
CREATE EXTENSION pg_stat_kcache;