• Pgadmin Download
• Installation Art Meaning
• Pgadmin3 Installation Articles

Current Maintainer Dave Page dpage@postgresql.org Policies Code of Conduct About PostgreSQL Contact. Copyright © 1996-2019 The PostgreSQL Global Development Group. PgAdmin 3 is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

I'm new to GIS related things and I'm setting up a Postgre/Postgis database for geospatial queries. I'd like to import various shapefiles into the database and I found that Pgadmin3 has a shapefile importer. How do I install the shapefile import plugin for pgadmin3 (I'm on Mountain Lion 10.8)?

Right now, the plugin menu is empty, and I have the very latest of Postgres and Postgis. See my comment below about what I've seen elsewhere on this topic.

3 Answers

I decided to go ahead and use the command line utility (shp2pgsql) to import my .shp file. Since I was able to get it working without too much trouble and a little Googling around I wanted to share this possible solution for anyone else who just wants to import a .shp file into Postgres and didn't want to deal with the hassle of trying to get pgadmin's GUI geospatial data importer. To import a shapefile here is the command (of course you need both Postgres and Postgis installed, first):

And here's the OpenGeo docs explaining each of the above parameters:

The command parameters are:
<SRID>Spatial reference identifier
<PATH/TO/SHAPEFILE>Full path to the shapefile (such as C:MyDataroadsroads.shp)
<SCHEMA>Target schema where the new table will be created
<DBTABLE>New database table to be created (usually the same name as the source shapefile)
<DATABASE>Target database where the table will be created

So just as an example, here was my command:

If you're not sure where to get the SRID just go here and upload your .prj file and use the topmost match it generates: http://prj2epsg.org/search

And for a comprehensive explanation of this CLI and importing data in general, just check out this great documentation from OpenGeo: http://suite.opengeo.org/docs/dataadmin/pgGettingStarted/shp2pgsql.html

I hope this helps someone!

Pgadmin Download

You might have to add the following to your plugins.ini file:

You'll most probably have to tweak the paths a little to fit your configuration. I got this file from the OpenGeo Suite install. Hopefully this should be enough to point you in the right direction. Good luck!

R.K.'s answer is heading in the right direction. Unfortunately, the pgShapeLoader.app file is needed (within /Applications/OpenGeo/), otherwise the script with plugins.ini will now execute properly (it has no file to reference). I'm not sure the file is available anywhere other than OpenGeoSuite. Ironically, if you download the OpenGeoSuite and install postGIS from it, the phShapeLoader should already be installed and ready to go.

Not the answer you're looking for? Browse other questions tagged postgisshapefilepostgresqlpgadmin-3 or ask your own question.

PostgreSQL Core Distribution

The core of the PostgreSQL object-relational database management systemis available in several source and binary formats.

Binary packages

Pre-built binary packages are available for a number of different operatingsystems:

• BSD
• Linux
  • Red Hat family Linux (including CentOS/Fedora/Scientific/Oracle variants)
  • Debian GNU/Linux and derivatives
  • Ubuntu Linux and derivatives
  • SuSE and OpenSuSE
  • Other Linux

Source code

The source code can be found in the main file browseror you can access the source control repository directlyat git.postgresql.org.Instructions for building from source can be found in thedocumentation.

Beta/RC Releases and development snapshots (unstable)

There are source code and binary packagesof beta and release candidates, and of the current development code availablefor testing and evaluation of new features. Note that these builds shouldbe used for testing purposes only, and not for production systems.

3rd party distributions

Big Data Analytics with PostgreSQL

2ndQuadrant Unified Data Analytics(2UDA – pronounced tudor) is a data analytics application suitethat unifies databases, spreadsheets, data mining and visualisation in oneseamless desktop installer. Once installed, 2UDA gives users access to thedramatic data visualisation and data mining capabilities of Orange, utilizingthe latest big data features of PostgreSQL, as well as the spreadsheetfunction of LibreOffice Calc.

Ready to run stacks

'LAPP', 'MAPP' and 'WAPP' (Linux/Mac/Windows + Apache + PHP + PostgreSQL)stacks are available fromBitNami.

Additional Software

Installation Art Meaning

Software Catalogue

There is much software available that is not bundled with PostgreSQL. The SoftwareCatalogue offers a listing of many commercial and Open Source applications, interfaces and extensions to PostgreSQLthat you may find useful.

If you wish to have your product listed in the catalogue, please fill out this form.

File Browser

Pgadmin3 Installation Articles

You can download most of the software we publish from a mirror site using our File Browser.