PostgreSQL 18 drops system dir requirement for extensions via extension_control_path
PostgreSQL 18 introduces the extension_control_path GUC, allowing extensions to be installed in arbitrary directories rather than the system-wide extension directory. This change decouples extension location from the core installation structure, enabling more flexible deployment strategies. The update removes the previous hard constraint that forced all extensions into a fixed system path.
Extensions can now reside in custom directories via extension_control_path