Installing an extension
Extensions that have been packaged for you by your friendly distribution manager are very simple to install using the following command:
CREATE EXTENSION extension_name;
Most of the popular Linux distributions include a package called something like postgresql-contrib-9.4. This naming convention is left over from the contrib style installation of PostgreSQL objects. Don't worry, for PostgreSQL 9.4, this package will actually provide extensions rather than contrib modules.
To find out where the files were placed on Ubuntu Linux, you can execute the following command:
pg_config --sharedir
This will show you the installation directory of shared components:
/usr/share/postgresql/9.4
The extensions will be located in a directory ...
Get PostgreSQL Server Programming - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
