<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 out <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>✅ <strong>readonly</strong> role. A readonly role set up by default for the public schema.</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/plv8/plv8" rel="noopener" target="_blank">plv8</a> - Write in Javascript functions in Postgres.</li>
<li>✅ <a href="https://www.postgresql.org/docs/current/plpython-python23.html" rel="noopener" target="_blank">plpython3u</a> - Python3 enabled by default. Write in Python functions in Postgres.</li>
</ul>

## Postgres + Goodies

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 out [github repository](<https://github.com/supabase/postgres>).

## Features

- ✅ Postgres [12](<https://www.postgresql.org/about/news/1976/>). Includes [generated columns](<https://www.postgresql.org/docs/12/ddl-generated-columns.html>) and [JSON path](<https://www.postgresql.org/docs/12/functions-json.html#FUNCTIONS-SQLJSON-PATH>) support
- ✅ Ubuntu 18.04 (Bionic) 
- ✅ [pg-contrib-12](<https://www.postgresql.org/docs/12/contrib.html>). Because everyone should enable `pg_stat_statements`.
- ✅ **readonly** role. A readonly role set up by default for the public schema.
- ✅ [wal\_level](<https://www.postgresql.org/docs/current/runtime-config-wal.html>) = logical and [max\_replication\_slots](<https://www.postgresql.org/docs/current/runtime-config-replication.html>) = 5. Ready for replication.
- ✅ [PostGIS](<https://postgis.net/>). Postgres' most popular extension - support for geographic objects.
- ✅ [pgTAP](<https://pgtap.org/>). Unit Testing for Postgres.
- ✅ [pgAudit](<https://www.pgaudit.org/>). Generate highly compliant audit logs. 
- ✅ [plv8](<https://github.com/plv8/plv8>) \- Write in Javascript functions in Postgres.
- ✅ [plpython3u](<https://www.postgresql.org/docs/current/plpython-python23.html>) \- Python3 enabled by default. Write in Python functions in Postgres.



PostgreSQL

Unmodified Postgres with some useful plugins and extensions.