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.
- ✅ Postgres 13.
- ✅ Ubuntu 20.04 (Focal Fossa).
- ✅ wal_level = logical and max_replication_slots = 5. Ready for replication.
- ✅ Large Systems Extensions. Enabled for ARM images.
| Extension | Description |
|---|---|
| Postgres contrib modules | Because everyone should enable pg_stat_statements. |
| PostGIS | Postgres' most popular extension - support for geographic objects. |
| pgRouting | Extension of PostGIS - provides geospatial routing functionalities. |
| pgTAP | Unit Testing for Postgres. |
| pg_cron | Run CRON jobs inside Postgres. |
| pgAudit | Generate highly compliant audit logs. |
| pgjwt | Generate JSON Web Tokens (JWT) in Postgres. |
| pgsql-http | HTTP client for Postgres. |
| plpgsql_check | Linter tool for P 9D26 L/pgSQL. |
| pg-safeupdate | Protect your data from accidental updates or deletes. |
| wal2json | JSON output plugin for logical replication decoding. |
| PL/Java | Write in Java functions in Postgres. |
| plv8 | Write in Javascript functions in Postgres. |
Can't find your favorite extension? Suggest for it to be added into future versions here!
Aside from having ufw,fail2ban, and unattended-upgrades installed, we also have the following enhancements in place:
| Enhancement | Description |
|---|---|
| fail2ban filter for PostgreSQL access | Monitors for brute force attempts over at port 5432. |
| fail2ban filter for PgBouncer access | Monitors for brute force attempts over at port 6543. |
| Goodie | Description |
|---|---|
| PgBouncer | Set up Connection Pooling. |
| PostgREST | Instantly transform your database into an RESTful API. |
| WAL-G | Tool for physical database backup and recovery. |
See all installation instructions in the repo wiki.
| Postgres & Extensions | PgBouncer | PostgREST | WAL-G | |
|---|---|---|---|---|
| Supabase Postgres | ✔️ | ❌ | ❌ | ✔️ |
| Supabase Postgres: PgBouncer Bundle | ✔️ | ✔️ | ❌ | ✔️ |
| Supabase Postgres: PostgREST Bundle | ✔️ | ❌ | ✔️ | ✔️ |
| Supabase Postgres: Complete Bundle | ✔️ | ✔️ | ✔️ | ✔️ |
| AWS ARM | AWS x86 | Digital Ocean x86 | |
|---|---|---|---|
| Supabase Postgres | Coming Soon | Coming Soon | Coming Soon |
| Supabase Postgres: PgBouncer Bundle | Coming Soon | Coming Soon | Coming Soon |
| Supabase Postgres: PostgREST Bundle | Coming Soon | Coming Soon | Coming Soon |
| Supabase Postgres: Complete Bundle | Coming Soon | Coming Soon | Coming Soon |
$ time packer build -timestamp-ui \
--var "aws_access_key=<insert aws access key>" \
--var "aws_secret_key=<insert aws secret key>" \
--var "ami_regions=<insert desired regions>" \
amazon-arm.jsonAfter talking to a lot of techies, we've found that most believe Postgres is the best (operational) database but they still choose other databases. This is overwhelmingly because "the other one was quicker/easier". Our goal is to make it fast and simple to get started with Postgres, so that we never hear that excuse again.
Our secondary goal is to show off a few of Postgres' most exciting features. This is to convince new developers to choose it over other database (a decision we hope they'll appreciate once they start scaling).
Finally, this is the same build we offer at Supabase, and everything we do is opensource. This repo makes it easy to install Postgres, Supabase makes it easy to use Postgres.
- Support for more images
- Vote for more plugins/extensions
- Open a github issue if you have a feature request
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).
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.