The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

mroswell (4) [Avatar] Offline
shp2pgsql-gui is not apparently available as a plugin in a default windows install. I have no plugins installed by default for pgAdmin III.

Thus the instructions:

Using pgAdmin III, we first highlight the database and then fire up shp2pgsql-gui using the plug-in menu or button. See figure 1.4.

didn't work for me.

Luckily, I found shp2pgsql-gui.exe in an executable file on my windows install.

Also note: Figure 1.4 is a bit small and fuzzy, and hard to read.
I can tell that the text says to change the name to: highways_staging, while the graphic itself shows the word "roads."

I also suggest specifically mentioning (not just in the graphic) to change the schema to ch01. I foolishly lost about an hour looking for the table the first time I imported it, because it landed in 'public' and I didn't see it there. I'm sure I wouldn't have missed it, though, if it was mentioned in the text.

(I'm still not sure of what schema are... but perhaps all will be revealed as I progress.)

regina.leo (265) [Avatar] Offline
Re: shp2pgsql-gui instructions
You should. Which version of pgAdmin III are you using.

What often causes this problem is if you have multiple versions of PostgreSQL on your system, and the pgAdmin you are using is not pointing at the binary location where you PostgreSQL with PostGIS is installed.

This link we wrote a while ago might help:
FLGM (3) [Avatar] Offline
Re: shp2pgsql-gui instructions
The case was the same for me. I had to use the executable as the only plugin I have available in my pgAdmin III plugin list is the PSQL Console.

Version string PostgreSQL 9.1.9, compiled by Visual C++ build 1500, 64-bit

PostGIS 2.0 for PSQL 9.1 (v. 2.0.3)

pgAdmin II (v. 1.14.3)

Message was edited by:
regina.leo (265) [Avatar] Offline
Re: shp2pgsql-gui instructions
Under file->Options-Binary Paths -- what does your PG bin path read?

The pgAdmin only install and the pgAdmin that comes with PostgreSQL are slightly different. For PostgreSQL pgAdmin this should point to the bin folder of your PostgreSQL install and you should have plugins.d folder in your /pgAdmin III of (install folder/pgAdmin III)

The plugins.d should have a file called postgis.shp2pgsql-gui.ini