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:
"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:
"psql: server closed the connection unexpectedlyI don't think the command is the problem- seems like PostgreSQL is disconnecting then reconnecting.. any ideas?
This probably means the server terminated abnormally
before or while processing the request.
Shapefile type: Arc
Postgis type: MULTILINESTRING"
System: Windows Vista 64-bit, 6Gb RAM, PostgreSQL 8.3.7, PostGIS 1.3.5.