supabase/postgres

By supabase

Updated 1 day ago

Unmodified Postgres with some useful plugins.

Image
46

5M+

Overview

Find out more in our github repository.

To get started create a docker-compose.yml with the following:

version: '3'

# Before supabase/postgres 14.1.0
services:
  db:
    image: supabase/postgres
    ports:
      - "5432:5432"
    environment:
      POSTGRES_PASSWORD: postgres

# supabase/postgres 14.1.0 and beyond
services:
  db:
    image: supabase/postgres
    ports:
      - "5432:5432"
    command: postgres -c config_file=/etc/postgresql/postgresql.conf 
    environment:
      POSTGRES_PASSWORD: postgres

and then run: docker-compose up (add -d to run in detached mode). The database should now be available in port 5432.

As the image is based on the postgreSQL image, environment variables from the PostgreSQL image are applicable to this image.

Extensions

ExtensionVersionDescription
Postgres contrib modules-Because everyone should enable pg_stat_statements.
PostGIS3.1.4Postgres' most popular extension - support for geographic objects.
pgRoutingv3.3.0Extension of PostGIS - provides geospatial routing functionalities.
pgTAPv1.1.0Unit Testing for Postgres.
pg_cronv1.4.1Run CRON jobs inside Postgres.
pgAudit1.6.1Generate highly compliant audit logs.
pgjwtcommitGenerate JSON Web Tokens (JWT) in Postgres.
pgsql-http1.3.1HTTP client for Postgres.
plpgsql_check2.0.6Linter tool for PL/pgSQL.
pg-safeupdate1.4Protect your data from accidental updates or deletes.
wal2json2.4JSON output plugin for logical replication decoding.
PL/Java1.6.3Write in Java functions in Postgres.
plv8commitWrite in Javascript functions in Postgres.
pg_plan_filtercommitOnly allow statements that fulfill set criteria to be executed.
pg_netv0.3Expose the SQL interface for async networking.
rum1.3.9An alternative to the GIN index.
pg_hashidscommitGenerate unique identifiers from numbers.
pg_sodiumv1.3.0Modern encryption API using libsodium.

Can't find your favorite extension? Suggest for it to be added into future releases here!

Docker Pull Command

docker pull supabase/postgres