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

✅ Postgres postgresql-15.8
✅ Postgres orioledb-postgresql-17_5
✅ Ubuntu 20.04 (Focal Fossa).
✅ wal_level = logical and max_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.4.5	Various Foreign Data Wrappers (FDWs) for PostreSQL
supautils	2.6.0	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.2.9	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.4.5	Various Foreign Data Wrappers (FDWs) for PostreSQL
supautils	2.6.0	PostgreSQL extension for enhanced security
vault	0.2.9	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 the repo 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 at Supabase.
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).

Sponsors

We are building the features of Firebase using enterprise-grade, open source products. We support existing communities wherever possible, and if the products don’t exist we build them and open source them ourselves.

License

gytis-ivaskevicius/supabase-postgres

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages