How do I import modules or install extensions in PostgreSQL 9 1

Question

Firstly  if you re not using 9 1   please refer to this question   How do I install an extension to PostgreSQL 9 1

User · Accepted Answer

Postgrseql 9 1 provides for a new command CREATE EXTENSION  You should use it to install modules    Modules provided in 9 1 can be found here   The include   adminpack   auth delay   auto explain   btree gin   btree gist   chkpass   citext   cube   dblink   dict int   dict xsyn   dummy seclabel   earthdistance   file fdw   fuzzystrmatch   hstore   intagg   intarray   isn   lo   ltree   oid2name   pageinspect   passwordcheck   pg archivecleanup   pgbench   pg buffercache   pgcrypto   pg freespacemap   pgrowlocks   pg standby   pg stat statements   pgstattuple   pg test fsync   pg trgm   pg upgrade   seg   sepgsql   spi   sslinfo   tablefunc   test parser   tsearch2   unaccent   uuid-ossp   vacuumlo   xml2   If for instance you wanted to install earthdistance  simply use this command   CREATE EXTENSION earthdistance    If you wanted to install an extension with a hyphen in its name  like uuid-ossp  you need to enclose the extension name in double quotes   CREATE EXTENSION  uuid-ossp      Read more about contrib  and the modules available in 9 1  Read about the new extension infrastructure  and the SQL commands to manage it here You can now more easily uninstall a module  see DROP EXTENSION  You can also get an extension list  and there is basic support for version numbers

User · Answer

While Evan Carrol s answer is correct  please note that you need to install the postgresql contrib package in order for the CREATE EXTENSION command to work   In Ubuntu 12 04 it would go like this   sudo apt-get install postgresql-contrib   Restart the postgresql server   sudo  etc init d postgresql restart   All available extension are in    usr share postgresql 9 1 extension    Now you can run the CREATE EXTENSION command

User · Answer

In addition to the extensions which are maintained and provided by the core PostgreSQL development team  there are extensions available from third parties   Notably  there is a site dedicated to that purpose  http   www pgxn org

User · Answer

The extensions available for each version of Postgresql vary  An easy way to check which extensions are available is  as has been already mentioned   SELECT   FROM pg available extensions    If the extension that you are looking for is available  you can install it using   CREATE EXTENSION  extensionName     or if you want  to drop it use   DROP EXTENSION  extensionName     With psql you can additionally check if the extension has been successfully installed using  dx  and find more details about the extension using  dx  extensioName  It returns additional information about the extension  like which packages are used with it   If the extension is not available in your Postgres version  then you need to download the necessary binary files and libraries and locate it them at  usr share conrib

User · Answer

How to download and install if you have SUSE  As an example I am downloading the tablefunc module so I can use crosstab  I have PostgreSQL 9 6 1   right-click desktop  terminal  type   sudo zypper in postgreql-contrib   Enter credentials  continue by typing   y   Run query  I ran mine from pgAdminIII    CREATE EXTENSION tablefunc    You should now have the crosstab function   I did not have to restart

User · Answer

Into psql terminal put    i  lt path to contrib files gt    in ubuntu it usually is  usr share postgreslq  lt your pg version gt  contrib  lt contrib file gt  sql

User · Answer

For the postgrersql10   I have solved it with   yum install postgresql10-contrib   Don t forget to activate extensions in postgresql conf  shared preload libraries    pg stat statements  pg stat statements track   all   then of course restart   systemctl restart postgresql-10 service    all of the needed extensions you can find here    usr pgsql-10 share extension

[postgresql] How do I import modules or install extensions in PostgreSQL 9.1+?

Examples related to postgresql

Examples related to postgresql-9.1