8.3.14. PostgreSQL extensions

Important points:

  • When enabling an extension, all its dependencies (if any) are automatically enabled.
  • When disabling an extension, its dependencies are checked. If any extension depends on the current one, instead of disabling it, a message is displayed stating that the dependent extension must be disabled first.

PostgreSQL extensions are configured individually for each database in the "PostgreSQL" section of the "Databases" tab with the 🔌 button:

Enabling and disabling extensions is performed without restarting the instance:

List of available extensions:

  1. address_standardizer
  2. address_standardizer_data_us
  3. adminpack (only for PostgreSQL 16)
  4. amcheck
  5. autoinc
  6. bloom
  7. btree_gin
  8. btree_gist
  9. citext
  10. cube
  11. dblink
  12. dict_int
  13. dict_xsyn
  14. earthdistance
  15. file_fdw
  16. fuzzystrmatch
  17. hstore
  18. insert_username
  19. intagg
  20. intarray
  21. isn
  22. lo
  23. ltree
  24. moddatetime
  25. old_snapshot (only for PostgreSQL 16)
  26. pageinspect
  27. pg_buffercache
  28. pg_cron (before enabling the plugin, in instance settings in the "cron.database_name" field, specify the name of the current DB)
  29. pg_freespacemap
  30. pg_prewarm
  31. pg_stat_statements
  32. pg_surgery
  33. pg_textsearch (not available for PostgreSQL 16)
  34. pg_trgm
  35. pg_visibility
  36. pg_walinspect
  37. pgcrypto
  38. pgrowlocks
  39. pgstattuple
  40. plpgsql
  41. postgis
  42. postgis_raster
  43. postgis_sfcgal
  44. postgis_tiger_geocoder
  45. postgis_topology
  46. postgres_fdw
  47. refint
  48. seg
  49. sslinfo
  50. tablefunc
  51. tcn
  52. timescaledb
  53. tsm_system_rows
  54. tsm_system_time
  55. unaccent
  56. uuid-ossp
  57. vector
  58. xml2
Content