dynamic_library_path

A parameter determining the file path for loadable modules

dynamic_library_path is a configuration parameter determing the file system path for dynamically loadable modules.

dynamic_library_path was added in PostgreSQL 7.2.

Defaut value

The default value for dynamic_library_path is: $libdir.

$libdir is a placeholder value representing the compiled-in PostgreSQL package library directory; this can be determined with pg_config --pkglibdir.

Change history

Examples

Determining the defaullt library path represented by $libdir:

postgres=# SHOW dynamic_library_path;
 dynamic_library_path 
----------------------
 $libdir
(1 row)

postgres=# SELECT setting FROM pg_config WHERE name='PKGLIBDIR';
             setting             
--------------------------------
 /usr/local/pg12/lib/postgresql
(1 row)

Alternatively, use the pg_config server utility:

$ pg_config --pkglibdir
/usr/local/pg12/lib/postgresql

Categories

GUC configuration item

See also

LOAD, CREATE FUNCTION