Skip to content

Add the missing extensions for Supabase

Goal

during testing, it turned out that the extended-postgres image does not have some extensions that are installed by default in the "postgres" database for Supabase.

For full compatibility with Supabase, we should add the missing extensions to the image.

  1. address_standardizer (https://github.com/postgis/postgis)
  2. address_standardizer_data_us (https://github.com/postgis/postgis)
  3. http (https://github.com/pramsey/pgsql-http)
  4. pg_graphql (https://github.com/supabase/pg_graphql)
  5. pg_hashids (https://github.com/iCyberon/pg_hashids)
  6. pg_jsonschema (https://github.com/supabase/pg_jsonschema)
  7. pg_net (https://github.com/supabase/pg_net)
  8. pg_stat_monitor (https://github.com/percona/pg_stat_monitor)
  9. pgjwt (https://github.com/michelp/pgjwt)
  10. pgrouting (https://github.com/pgRouting/pgrouting)
  11. pgsodium (https://github.com/michelp/pgsodium)
  12. pgtap (https://github.com/theory/pgtap)
  13. plcoffee (https://github.com/plv8/plv8)
  14. pljava (https://github.com/tada/pljava)
  15. plls (https://github.com/plv8/plv8)
  16. plpgsql_check (https://github.com/okbob/plpgsql_check)
  17. plv8 (https://github.com/plv8/plv8)
  18. postgis (https://github.com/postgis/postgis)
  19. postgis_raster (https://github.com/postgis/postgis)
  20. postgis_sfcgal (https://github.com/postgis/postgis)
  21. postgis_tiger_geocoder (https://github.com/postgis/postgis)
  22. postgis_topology (https://github.com/postgis/postgis)
  23. rum (https://github.com/postgrespro/rum)
  24. supautils (https://github.com/supabase/supautils)

TODO / How to implement

add the necessary extensions to the "extended-postgres" images.

Acceptance criteria

Edited by Vitaliy Kukharik