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.
[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.