Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 1,664 Commits
.github		.github
ansible		ansible
docker		docker
docs/img		docs/img
ebssurrogate		ebssurrogate
http		http
migrations		migrations
nix		nix
rfcs		rfcs
scripts		scripts
testinfra		testinfra
tests/pg_upgrade		tests/pg_upgrade
.envrc.recommended		.envrc.recommended
.gitignore		.gitignore
CONTRIBUTING.md		CONTRIBUTING.md
Dockerfile-15		Dockerfile-15
Dockerfile-17		Dockerfile-17
Dockerfile-kubernetes		Dockerfile-kubernetes
Dockerfile-orioledb-17		Dockerfile-orioledb-17
LICENSE		LICENSE
Makefile		Makefile
README.md		README.md
amazon-arm64-nix.pkr.hcl		amazon-arm64-nix.pkr.hcl
ansible.cfg		ansible.cfg
development-arm.vars.pkr.hcl		development-arm.vars.pkr.hcl
flake.lock		flake.lock
flake.nix		flake.nix
meta-data		meta-data
postgresql.gpg.key		postgresql.gpg.key
qemu-arm64-nix.pkr.hcl		qemu-arm64-nix.pkr.hcl
qemu_artifact.md		qemu_artifact.md
stage2-nix-psql.pkr.hcl		stage2-nix-psql.pkr.hcl
user-data-cloudimg		user-data-cloudimg

Repository files navigation

Postgres + goodies

Unmodified Postgres with some useful plugins. Our goal with this repo is not to modify Postgres, but to provide some of the most common extensions with a one-click install.

Primary Features

✅ Postgrespostgresql-15.8
✅ Postgrespostgresql-17.4
✅ Postgresorioledb-postgresql-17_6
✅ Ubuntu 20.04 (Focal Fossa).
✅wal_level = logical andmax_replication_slots = 5. Ready for replication.
✅Large Systems Extensions. Enabled for ARM images.

Extensions

PostgreSQL 15 Extensions

Extension	Version	Description
hypopg	1.4.1	Hypothetical Indexes for PostgreSQL
index_advisor	0.2.0	Recommend indexes to improve query performance in PostgreSQL
pg-safeupdate	1.4	A simple extension to PostgreSQL that requires criteria for UPDATE and DELETE
pg_cron	1.6.4	Run Cron jobs through PostgreSQL
pg_graphql	1.5.11	GraphQL support for PostreSQL
pg_hashids	cd0e1b31d52b394a0df64079406a14a4f7387cd6	Generate short unique IDs in PostgreSQL
pg_jsonschema	0.3.3	JSON Schema Validation for PostgreSQL
pg_net	0.14.0	Async networking for Postgres
pg_plan_filter	5081a7b5cb890876e67d8e7486b6a64c38c9a492	Filter PostgreSQL statements by execution plans
pg_repack	1.5.2	Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_monitor	2.1.0	Query Performance Monitoring Tool for PostgreSQL
pg_tle	1.4.0	Framework for 'Trusted Language Extensions' in PostgreSQL
pgaudit	1.7.0	Open Source PostgreSQL Audit Logging
pgjwt	9742dab1b2f297ad3811120db7b21451bca2d3c9	PostgreSQL implementation of JSON Web Tokens
pgmq	1.4.4	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgroonga	3.2.5	A PostgreSQL extension to use Groonga as the index
pgrouting	3.4.1	A PostgreSQL/PostGIS extension that provides geospatial routing functionality
pgsodium	3.1.8	Modern cryptography for PostgreSQL
pgsql-http	1.6.1	HTTP client for Postgres
pgtap	1.2.0	A unit testing framework for PostgreSQL
pgvector	0.8.0	Open-source vector similarity search for Postgres
plpgsql-check	2.7.11	Linter tool for language PL/pgSQL
plv8	3.1.10	V8 Engine Javascript Procedural Language add-on for PostgreSQL
postgis	3.3.7	Geographic Objects for PostgreSQL
rum	1.3.14	Full text search index method for PostgreSQL
supabase-wrappers	0.5.0	Various Foreign Data Wrappers (FDWs) for PostreSQL
supautils	2.9.4	PostgreSQL extension for enhanced security
timescaledb-apache	2.16.1	Scales PostgreSQL for time-series data via automatic partitioning across time and space
vault	0.3.1	Store encrypted secrets in PostgreSQL
wal2json	2_6	PostgreSQL JSON output plugin for changeset extraction

PostgreSQL 17 Extensions

Extension	Version	Description
hypopg	1.4.1	Hypothetical Indexes for PostgreSQL
index_advisor	0.2.0	Recommend indexes to improve query performance in PostgreSQL
pg-safeupdate	1.4	A simple extension to PostgreSQL that requires criteria for UPDATE and DELETE
pg_cron	1.6.4	Run Cron jobs through PostgreSQL
pg_graphql	1.5.11	GraphQL support for PostreSQL
pg_hashids	cd0e1b31d52b394a0df64079406a14a4f7387cd6	Generate short unique IDs in PostgreSQL
pg_jsonschema	0.3.3	JSON Schema Validation for PostgreSQL
pg_net	0.14.0	Async networking for Postgres
pg_plan_filter	5081a7b5cb890876e67d8e7486b6a64c38c9a492	Filter PostgreSQL statements by execution plans
pg_repack	1.5.2	Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_monitor	2.1.0	Query Performance Monitoring Tool for PostgreSQL
pg_tle	1.4.0	Framework for 'Trusted Language Extensions' in PostgreSQL
pgaudit	17.0	Open Source PostgreSQL Audit Logging
pgjwt	9742dab1b2f297ad3811120db7b21451bca2d3c9	PostgreSQL implementation of JSON Web Tokens
pgmq	1.4.4	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgroonga	3.2.5	A PostgreSQL extension to use Groonga as the index
pgrouting	3.4.1	A PostgreSQL/PostGIS extension that provides geospatial routing functionality
pgsodium	3.1.8	Modern cryptography for PostgreSQL
pgsql-http	1.6.1	HTTP client for Postgres
pgtap	1.2.0	A unit testing framework for PostgreSQL
pgvector	0.8.0	Open-source vector similarity search for Postgres
plpgsql-check	2.7.11	Linter tool for language PL/pgSQL
postgis	3.3.7	Geographic Objects for PostgreSQL
rum	1.3.14	Full text search index method for PostgreSQL
supabase-wrappers	0.5.0	Various Foreign Data Wrappers (FDWs) for PostreSQL
supautils	2.9.4	PostgreSQL extension for enhanced security
vault	0.3.1	Store encrypted secrets in PostgreSQL
wal2json	2_6	PostgreSQL JSON output plugin for changeset extraction

PostgreSQL orioledb-17 Extensions

Extension	Version	Description
hypopg	1.4.1	Hypothetical Indexes for PostgreSQL
index_advisor	0.2.0	Recommend indexes to improve query performance in PostgreSQL
orioledb	orioledb	orioledb
pg-safeupdate	1.4	A simple extension to PostgreSQL that requires criteria for UPDATE and DELETE
pg_cron	1.6.4	Run Cron jobs through PostgreSQL
pg_graphql	1.5.11	GraphQL support for PostreSQL
pg_hashids	cd0e1b31d52b394a0df64079406a14a4f7387cd6	Generate short unique IDs in PostgreSQL
pg_jsonschema	0.3.3	JSON Schema Validation for PostgreSQL
pg_net	0.14.0	Async networking for Postgres
pg_plan_filter	5081a7b5cb890876e67d8e7486b6a64c38c9a492	Filter PostgreSQL statements by execution plans
pg_repack	1.5.2	Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_monitor	2.1.0	Query Performance Monitoring Tool for PostgreSQL
pg_tle	1.4.0	Framework for 'Trusted Language Extensions' in PostgreSQL
pgaudit	17.0	Open Source PostgreSQL Audit Logging
pgjwt	9742dab1b2f297ad3811120db7b21451bca2d3c9	PostgreSQL implementation of JSON Web Tokens
pgmq	1.4.4	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgroonga	3.2.5	A PostgreSQL extension to use Groonga as the index
pgrouting	3.4.1	A PostgreSQL/PostGIS extension that provides geospatial routing functionality
pgsodium	3.1.8	Modern cryptography for PostgreSQL
pgsql-http	1.6.1	HTTP client for Postgres
pgtap	1.2.0	A unit testing framework for PostgreSQL
pgvector	0.8.0	Open-source vector similarity search for Postgres
plpgsql-check	2.7.11	Linter tool for language PL/pgSQL
postgis	3.3.7	Geographic Objects for PostgreSQL
rum	1.3.14	Full text search index method for PostgreSQL
supabase-wrappers	0.5.0	Various Foreign Data Wrappers (FDWs) for PostreSQL
supautils	2.9.4	PostgreSQL extension for enhanced security
vault	0.3.1	Store encrypted secrets in PostgreSQL
wal2json	2_6	PostgreSQL JSON output plugin for changeset extraction

Additional Goodies

This is only available for our AWS EC2

Goodie	Version	Description
PgBouncer	1.19.0	Set up Connection Pooling.
PostgREST	v12.2.3	Instantly transform your database into an RESTful API.
WAL-G	v2.0.1	Tool for physical database backup and recovery.

Install

See all installation instructions in therepo wiki.

Motivation

Make it fast and simple to get started with Postgres.
Show off a few of Postgres' most exciting features.
This is the same build we offer atSupabase.
Open a github issue if you have a feature request

License

The PostgreSQL License. We realize that licensing is tricky since we are bundling all the various plugins. If we have infringed on any license, let us know and we will make the necessary changes (or remove that extension from this repo).