GPSFileDepot.com
 

News:

Welcome to GPSFileDepot!

Main Menu

Export Shapefile from PostGIS

Started by Tsnake, December 13, 2008, 06:26:43 PM

Previous topic - Next topic

Tsnake

I have compiled all the NHD info into PostgreSQL.  When I try to export the data to a shapefile, it starts fine, but when it starts dumping, an error message comes up that says pgsql2shp.exe has stopped working. 

I am running Windows Vista Home Premium 32 bit.  Any ideas?

Tsnake

-Oz-

Yes!  Another user with the same issue.  I am on Vista Business and get the same error.  Now that I know someone else has that error I'll send a message to the postGIS people and see what they have to say.

Regrettably I have no solution at this time.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

-Oz-

Been in contact with the developer; they're working on it.  Its failing on a lot of people (everyone)'s vista.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

-Oz-

#3
I've been in contact with the developer. 

Attached is a replacement file called version 1.3.6.  it works for me on vista and Xp so i'm having my new computer crank out the dem files now.

Hopefully it works for you too.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

aussieskier

Just an FYI I was getting errors on XP SP2, but this patched version seems to have fixed the problem.

-Oz-

Good to know; hopefully they'll officially release it soon.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

hntr

#6
Any news on getting PostGIS working with Vista?  I get an error when I try the patch 'libpq.dll was not found'

-Oz-

did you run as an administrator; the install?
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

-Oz-

the discussion group says just hit ignore on the error and it should all work fine.
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

hntr

I am using the admin account on this computer, so yes, I did install as the administrator.  however, I didn't select the 'run as administrator' option like I did with the Topo Process Program install (because this option wasn't available when I right click)

As far as the patch, the error is 'this application has failed to start because libpq.dll was not found.  Re-installing the application may fix the problem'
The only option is to hit OK and the program is forced to stop.  However, it may work without the patch, I was able to execute a few commands as described in your tutorial without the patch, but ran into errors down the line.  i will try it again

hntr

Quote from: -Oz- on March 04, 2009, 09:15:15 PM
did you run as an administrator; the install?

I uninstalled Postgresql to make sure I install as admin, but now to reinstall i need to manually delete the user postgres (or find the random password that was created).  How do i manually delete usernames from the server?

-Eric

P.S.  I installed it with a new username, but then PostGIS had errors on install.  This stuff might be over my head, especially because I have Vista!


dhisum_dhisum

On Vista:

Click on Start
In the little search box in the start menu, type "compmgmt.msc"

A window by the name "Computer Management" comes up.
There is a pane on the left, where the top node is called "Computer management', expand it, go to "Local users and groups", expand that and then click on "users", this will bring the list of "users" in the right pane. You should see the "postgres" user in this list. Right click on the postgres user and it will show option for "setting a password". Additionally, from this menu, you can delete the user as well.

hntr

OK thanks.

i was unable to find the 'Local users and groups'  listing (system tools, storage, and services and apps were the only options), but i was able to delete the user through the Control Panel

hntr

I still get an error when installing during the service configuration: 'Invalid username specified:  Logon Failure: unknown username or bad password'

Anything else i should try?

hntr

Quote from: -Oz- on March 05, 2009, 06:26:29 AM
the discussion group says just hit ignore on the error and it should all work fine.

OK postGIS and Postgresql seem to be working again.  I have connected to the server and can see the postgis database.  I went through the water data tutorial fine with PostgreSQL working fine until the last part 'Export Shapefiles from PostGIS'.  I get the error mentioned in the beginning of this post by Tsnake and I can't install the patch as described earlier. 

Anything else I can try?