[GIS] How to fix QGIS PostGIS Manager error ‘shp2pgsql’ is not recognized

postgispostgresqlqgisqgis-plugins

I have QGIS 1.8.0 installed via OSGeo Installer and work on win 7.
All I need is to upload the shapefile to the database via this plugin. Unfortunately I am receiving an error:

Something's wrong:
["'shp2pgsql' is not recognized as an internal or external command,\n", 'operable program or batch file.\n']

How to install and configure shp2pgsql to make this plugin work fine?

Best Answer

Shp2pgsql.exe should be in folder C:\Program Files (x86)\Postgresql\9.0\bin.

It might help to include the folder to the systems PATH variable (although it is not here with me).

I don't know how Qgis reacts if you updated your Postgres or Postgis version after installing Qgis.

Does the DB Manager plugin see your Postgis databases?

The plugin help gives this hint:

Note: not having PostGIS installed on your local machine or being installed in some non-standard location will render this feature unusable because of the missing shp2pgsql tool.

According to this message: http://osgeo-org.1560.n6.nabble.com/Re-Qgis-user-PostGIS-Manager-compatibility-issue-with-PostGIS-2-0-td4957715.html#a4958320 the Postgis manager plugin should be replaced by the DB manager.

Unfortunately, the option to import data is still missing. But you can drag and drop shapefiles from Qgis Browser to DB Manager plugin which will do the same.

Related Solutions

[GIS] Running TauDEM in QGIS

TauDEM appears as an option in QGIS's processing providers, but you still have to install it yourself, which is...unfortunate. The following worked for me:

System: Windows 7 64-bit, latest QGIS from the OsGeo4w installer (2.14 Essen)

Make sure the MS Visual C++ 2010 redistributables reccommended on the TauDEM support page are installed correctly - I had to remove and reinstall mine
Install the latest MS-MPI package, which is v7 at present - just google 'MS-MPI' and it should be result #1.
Install TauDEM from the source at -http://hydrology.usu.edu/taudem/taudem5/downloads.html. You'll have to provide a name and email to access the windows installer. That will also install a couple of things if you don't already have them, notably standalone GDAL - just roll with it.

In QGIS, open the Processing Options dialogue where you can enable TauDEM. Set the following options:

MPICH2/OpenMPI bin Directory: C:\Program Files\Microsoft MPI\bin
TauDEM command line tools folder: C:\Program Files\TauDEM\TauDEM5Exe

your folder locations should be pretty much identical to the above, maybe with minor differences. Setting those paths in QGIS should be identical to editing the registry keys mentioned above directly in regedit.

Restart QGIS and then test one of the tools, you should be good to go.

[GIS] Making ‘make’-command work for compiling QGIS-plugins

You only really need to compile the resources of your plugin, in which case you can use:

pyrcc4 -o resources.py resources.qrc

No need to use make. If you want to properly clean up your resources, you could use make clean as described in this post: When I change a QGIS plugin's icon, why doesn't it change in the menu/toolbar?

Also, from the tutorial link you gave, a recent question was asked in the comments section :)

Best Answer

Related Solutions

[GIS] Running TauDEM in QGIS

[GIS] Making ‘make’-command work for compiling QGIS-plugins

Related Question