8.3.14. PostgreSQL extensions

Important points:

  • When enabling an extension, all its dependencies (if any) are automatically enabled.
  • For some extensions, you need to enable preloading in the settings.
  • 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 🔌 ("Extensions") 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
  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
  26. pageinspect
  27. pg_buffercache
  28. pg_cron (before enabling, you need to specify the name of the current DB in the "cron.database_name" field in the instance settings).
  29. pg_freespacemap
  30. pg_prewarm
  31. pg_stat_statements
  32. pg_surgery
  33. pg_textsearch (only for PostgreSQL 17+).
  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
目录