Postgresql 9.2 Install Dblink
Postgresql postgresql-9.2 dblink. Installing modules usually requires you to run an sql script that is included with the database installation. Find / -name dblink. Oct 18, 2010 - Postgresql 8.4.4 was installed from source at /var/lib/pgsql84, where all the source files were. To install dblink module from contrib, I followed the steps. I had to upgrade Postgresql 9.0 to 9.2 with less downtime.
I have installed the PostgreSQL9.2 and I need to use DBLink after searching through the internet, it is stated that the dblinke should be found under PostgreSQL9.2sharecontrib. In my case the contrib folder is empty. How can I install the DBlink in Windows?
PostgreSQL 9.2.24 Documentation. Dblink executes a query (usually a SELECT, but it can be any SQL statement that returns rows) in a remote database.
2 Answers
I managed to solve the problem by creating a folder dblink under the contrib folder and then I have copied the 3 files (dblink.control, dblink--1.0 and dblink--unpackaged--1.0) form shareextensions to the new folder sharecontribdblink and after i run the CREATE EXTENSION dblink in each database that i need.
Not the answer you're looking for? Browse other questions tagged postgresql or ask your own question.
Firstly, if you're not using 9.1+, please refer to this question.
How do I install an extension to PostgreSQL 9.1?
6 Answers
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,
If for instance you wanted to install earthdistance, simply use this command:
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:
- 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.
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:
Restart the postgresql server:
All available extension are in:
Now you can run the CREATE EXTENSION command.
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/
For the postgrersql10
I have solved it with
Don't forget to activate extensions in postgresql.conf
then of course restart
all of the needed extensions you can find here
Into psql terminal put:
in ubuntu it usually is /usr/share/postgreslq/<your pg version>/contrib/<contrib file>.sql
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:
Enter credentials, continue by typing:
Run query (I ran mine from pgAdminIII):
You should now have the crosstab function.
I did not have to restart.