Close
image - 2021-02-18T141057-svg

Supabase Postgres

By- Supabase (Version 0.13.0OS Ubuntu 18.04 )

Description

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 our github repository.

Features

  • ✅ Postgres 12. Includes generated columns and JSON path support
  • ✅ Ubuntu 18.04 (Bionic)
  • ✅ pg-contrib-12. Because everyone should enable pg_stat_statements.
  • ✅ wal_level = logical and max_replication_slots = 5. Ready for replication.
  • ✅ PostGIS. Postgres’ most popular extension – support for geographic objects.
  • ✅ pgTAP. Unit Testing for 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 PL/pgSQL.
  • ✅ plv8 – Write in Javascript functions in Postgres.
  • ✅ plpython3u – Python3 enabled by default. Write in Python functions in Postgres.
  • ✅ PL/Java. Write in Java functions in Postgres.

Software Included

Getting started after deploying Supabase Postgres

General Instructions

In addition to the package installation, this VM also enables the UFW firewall to allow port 22 for SSH and port 5432 for access to PostgreSQL. Once you have your VM up and running, you would first need to set up the password for your DB superuser postgres.

Support Details

Supported By: Superbase
Support URL: https://github.com/supabase/postgres/issues
Support Email: support@supabase.io