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!

Register Log in
  • Congratulations Chris Miller 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

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.

Similar threads

OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
182
OJSan
OJSan
MrCBofBCinTX
  • Locked
  • Question
public."returns"
Replies
1
Views
89
feherke
feherke
jj1576
  • Locked
  • Question
Ireport question- if then else based on datatype
Replies
0
Views
150
jj1576
jj1576
adventurous1
  • Locked
  • Question
Help! I need a function to look up the geography for an IP address
Replies
5
Views
195
adventurous1
adventurous1
timfoster
  • Locked
  • Question
How do I find out the create date of a table?
Replies
0
Views
106
timfoster
timfoster

Part and Inventory Search

Sponsor

Back
Top