<h2 id="postgres--goodies">Postgres + Goodies</h2>
<p>Unmodified Postgres with some useful plugins. Our goal is not to modify Postgres, but to provide some of the most common extensions with a one-click install. Find out more in our <a href="https://github.com/supabase/postgres" rel="noopener" target="_blank">github repository</a>.</p>
<h2 id="features">Features</h2>
<ul>
<li>✅ Postgres <a href="https://www.postgresql.org/about/news/1976/" rel="noopener" target="_blank">12</a>. Includes <a href="https://www.postgresql.org/docs/12/ddl-generated-columns.html" rel="noopener" target="_blank">generated columns</a> and <a href="https://www.postgresql.org/docs/12/functions-json.html#FUNCTIONS-SQLJSON-PATH" rel="noopener" target="_blank">JSON path</a> support.</li>
<li>✅ Ubuntu 18.04 (Bionic).</li>
<li>✅ <a href="https://www.postgresql.org/docs/12/contrib.html" rel="noopener" target="_blank">pg-contrib-12</a>. Because everyone should enable <code>pg_stat_statements</code>.</li>
<li>✅ <a href="https://www.postgresql.org/docs/current/runtime-config-wal.html" rel="noopener" target="_blank">wal_level</a> = logical and <a href="https://www.postgresql.org/docs/current/runtime-config-replication.html" rel="noopener" target="_blank">max_replication_slots</a> = 5. Ready for replication.</li>
<li>✅ <a href="https://postgis.net/" rel="noopener" target="_blank">PostGIS</a>. Postgres&#39; most popular extension - support for geographic objects.</li>
<li>✅ <a href="https://pgtap.org/" rel="noopener" target="_blank">pgTAP</a>. Unit Testing for Postgres.</li>
<li>✅ <a href="https://www.pgaudit.org/" rel="noopener" target="_blank">pgAudit</a>. Generate highly compliant audit logs.</li>
<li>✅ <a href="https://github.com/michelp/pgjwt" rel="noopener" target="_blank">pgjwt</a>. Generate JSON Web Tokens (JWT) in Postgres.</li>
<li>✅ <a href="https://github.com/pramsey/pgsql-http" rel="noopener" target="_blank">pgsql-http</a>. HTTP client for Postgres.</li>
<li>✅ <a href="https://github.com/okbob/plpgsql_check" rel="noopener" target="_blank">plpgsql_check</a>. Linter tool for PL/pgSQL.</li>
<li>✅ <a href="https://github.com/plv8/plv8" rel="noopener" target="_blank">plv8</a>. Write in Javascript functions in Postgres.</li>
<li>✅ <a href="https://github.com/tada/pljaval" rel="noopener" target="_blank">PL/Java</a>. Write in Java functions in Postgres.</li>
<li>✅ <a href="https://github.com/citusdata/pg_cron" rel="noopener" target="_blank">pg_cron</a>. Run CRON jobs inside Postgres.</li>
<li>✅ <a href="https://github.com/eradman/pg-safeupdate" rel="noopener" target="_blank">pg-safeupdate</a>. Protect your data from accidental updates or deletes.</li>
<li>✅ <a href="https://www.pgbouncer.org/" rel="noopener" target="_blank">PgBouncer</a>. Connection Pooling for PostgreSQL.</li>
</ul>

PostgreSQL

Unmodified Postgres with some useful plugins and extensions.