PostgreSQL DBA

Extensions & Contrib Modules

Question

CREATE EXTENSION versus loading a shared library: what differs, and when is each required?

Answer

CREATE EXTENSION installs database-local SQL objects and records them as an extension. shared_preload_libraries loads server libraries at startup for modules requiring shared-memory or startup hooks. Use CREATE EXTENSION for installed functionality; configure preload and restart where the module requires it.

This is 15 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples