CODEWITHSUNDEEP
postgresqlpgadmin
insivika
insivika

Reputation: 624

How to install HTTP extension on PGadmin

I'm attempting to add the HTTP extension to my pgadmin gui however when I run CREATE EXTENSION http I get ERROR: could not open extension control file "/usr/share/postgresql/14/extension/http.control": No such file or directory

The installation section on the readme is not very clear to me

Upvotes: 2

Views: 2314

Answers (2)

Miro J.
Miro J.

Reputation: 4994

In Windows, you can use DBeaver, which gives you a nice UI and good feedback. Double-click on your database, go to the Extensions tab, and click the Create New Extension button at the bottom. It takes care of permissions and authentication.

Upvotes: 0

cmarrero
cmarrero

Reputation: 31

There is no out of the box support for http in PostgreSQL; I installed the http extension following these instructions: If you are in linux: apt-get install postgresql-server-dev-16 (or your postgresql version) apt-get install libcurl4-gnutls-dev git clone https://github.com/pramsey/pgsql-http.git cd pgsql-http/ make make install

If you are in windows, go to http://www.postgresonline.com/journal/archives/371-http-extension.html and follow instructions

Then in a postgresql console or in pgAdmin, execute: CREATE EXTENSION http;

This is the repository addres in github: https://github.com/pramsey/pgsql-http.git

Hope this helps!

Upvotes: 2

Related Questions