Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"server closed the connection unexpectedly"

Status
Not open for further replies.

SirChasm

Technical User
Mar 30, 2009
1
US
I am trying to bulk load thousands of SHP files (TIGER2007 edges) into a PostGIS-enabled PostgreSQL db. I am using a simple batch file to append each county:

[tab]"shp2pgsql -a -s 4326 -D fe_2007_12085_edges.shp public.edges | psql tiger2007 postgres"

Randomly (different each time I run it) it fails on ~5-10 files and returns the message:

[tab]"psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[tab]Shapefile type: Arc
[tab]Postgis type: MULTILINESTRING[2]"

I don't think the command is the problem- seems like PostgreSQL is disconnecting then reconnecting.. any ideas?

System: Windows Vista 64-bit, 6Gb RAM, PostgreSQL 8.3.7, PostGIS 1.3.5.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top