Loading Shapefiles into PostGIS using shapefile import/export manager

Question

I am a complete beginner with PostGIS. I've started learning it using the tutorials provided by Boundless. In section 4 of this tutorial where I want to import shapefile in PostGIS, I do not have the PostGIS shapefile Import/Export Manager tool in the PgAdmin III.

I've followed the tutorial step by step. They have never pointed if I need to install such tool or how to activate it, etc. Any idea what the problem could be? and how I can solve this?

I've installed Postgresql 9.3, PostGIS 2.1 , pgAdmin3 1.12.3 on Windows Server 2012 R2 Standard.

by the way, the relevant page for this issue in the tutorial is at: http://postgis.net/workshops/postgis-intro/loading_data.html

Thanks!

• Below the Radar: Hi, welcome to GIS StackExchange. Please provide version of postgresql and postgis you installed and OS.
• Catlover: Thanks. the information you asked has been updated in the main question.
• Below the Radar: Look in C:/Program Files/PostgreSQL/9.3/bin/shp2pgsql.exe if you can find it
• Catlover: Yes. I executed it as admin, a separate window popped and closed immediately. Then I checked the plugin menu in pgAdmin III, nothing changed...
• Below the Radar: It should be default install with PostGIS and pgAdmin 1.18

Answer 1

You are looking for PostGIS 2.0 Shapefile and DBF Loader Exporter, so access "C:\Program Files\PostgreSQL9円.3\bin\postgisgui\shp2pgsql-gui.exe"

• Catlover: I can't find it in the specified folder... Do I need to re-install PostGIS?
• Sorin Călinică: Yes, definitely!
• Catlover: Can't I perhaps search and download only this package, instead of re-installing PostGIS? Will it work in that way?
• Sorin Călinică: Just try and see. It may be possible.
• Sorin Călinică: Download a bundle from here download.osgeo.org/postgis/windows/pg93 , unzip it and copy the postgisgui folder according to the link I gave you.