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 12
- ✅ Ubuntu 18.04 (Bionic)
- ✅ pg-contrib-12. Because everyone should enable
pg_stat_statements. - ⏳
readonlyrole. A readonly role set up by default for the public schema. - ✅ wal_level = logical. Ready for replication.
- ✅ PostGIS. Postgres' most popular extension - support for geographic objects.
- ✅ pgTAP. Unit Testing for Postgres
- ⏳ plv8 - coming soon. Write in Javascript functions in Postgres.
- ⏳ PL/python - coming soon. Write in Python functions in Postgres.
See all installation instructions in the repo wiki.
After talking to a lot of people, we've found that most techies 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 quick and simple to get started with Postgres, so that we never hear that excuse again.
This is also the same build we offer for Supabase, and everything we do is opensource.
- 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).