CODEWITHSUNDEEP
postgresqlpostgispgadmin
CodyBugstein
CodyBugstein

Reputation: 23352

How do I add PostGIS to PostgreSQL pgAdmin?

I've got PostgreSQL and pgAdmin installed, but I want to add a PostGIS server so I could work on a Geographic Informations System project.

I'm following this tutorial, which assumes PostGIS is set up. In the previous page of the tutorial, it instructs you to download their software package which includes PostgreSQL and pgAdmin. I already have those installed, so I would like to just add PostGIS but I don't see any way to do so.

Any ideas?

pgAdmin screenshot

Upvotes: 43

Views: 119554

Answers (6)

Niveditha S
Niveditha S

Reputation: 196

I faced the same problem. This is how I resolved it.

  1. I opened Application Stack Builder.

  2. I chose the installation that I need to add PostGIS to. enter image description here

  3. Under Spatial Extensions, I chose the PostGIS bundle that I needed. enter image description here

  4. Once the installation was done, I opened pgAdmin, Under the database that I was working on, I right clicked on Extensions. Clicked on create -> extension

enter image description here

  1. Selected postgis in the Name dropdown. Clicked on Save. And done. enter image description here

Upvotes: 0

Mayank Rathod
Mayank Rathod

Reputation: 1

its very simple just reinstall your postgres again with latest version during installation stack buider for postgres open simply open tick spatial extension and click postgis bundle for postgres and download it , after download open pgadmin4 and right click database click script , remove automatically generate script and paste this CREATE EXTENSION postgis;

Upvotes: 0

Firsake
Firsake

Reputation: 71

For PGAdmin installation of extensions:

  1. Right click on the database name listed under the server cascade list, you will see an option "Create Script" - click on it.

  2. This opens up a script with some information on creation/alteration of the DB. Clear this script and then paste the following lines:

    CREATE EXTENSION postgis;

  3. Look at the icons at the top - you will see a RUN icon/button - looks like a "play" icon. Click on it.

  4. Look at the Log output, it should have successfully run the command and installed the extension.

Upvotes: 2

aashish
aashish

Reputation: 2603

Before adding PostGIS extension to Postgres. You first need to install PostGIS on Ubuntu 14.04

Add PPA from terminal

$ sudo add-apt-repository ppa:ubuntugis/ppa
$ sudo apt-get update

Install PostGIS with apt-get

$ sudo apt-get install postgis postgresql-10-postgis-2.5

After successful installation open psql

$ sudo -u postgres psql

List all databases

postgres=# \l

Connect to specific database

postgres=# \c DATABASE_NAME

Run the following to add PostGIS extension to Postgres

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;

Exit from psql

postgres=# \q

Thank you

Upvotes: 50

jwd630
jwd630

Reputation: 4675

Connect to the database using a superuser account (most often the user named postgres but in more recent versions the id of the user who installed the application.) Then issue the following SQL commands to enable PostGIS functionality.

 CREATE EXTENSION postgis;
 CREATE EXTENSION postgis_topology;

You can do this from within pgAdmin or via psql -U [superuser] [database] from a command line.

Alternately for the command adverse; as a superuser; from within pgAdmin right click on your database's Extensions and select New Extension. Then in the drop down associated with Name select the postgis* extensions needed.

Upvotes: 63

John Powell
John Powell

Reputation: 12581

You don't install it to pgAdmin, it is an extension to Postgres itself. Once it is installed, you add it to a particular database, and its functions, nearly 1000, a few views and the spatial_ref_sys table, will appear in pgAdmin in that db. You can also install it to the template1 db, and then it will be automatically included in any other database that you subsequently create. You can get a binary install from http://postgis.net/install/

Upvotes: 5

Related Questions