Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to import a shapefile with polygons into Postgis (Windows 2008 server). If I import 100 polygons it works fine. If I try to import the full map of 8,100 polygons, about halfway I get an error window "Shape to PostGIS Converter has stopped working". Problem details (as shown in that window) are:

Problem signature: Problem Event Name: APPCRASH Application Name: shp2pgsql-gui.exe Application Version: 1.0.0.0 Application Timestamp: 505c6e19 Fault Module Name: libglib-2.0-0.dll Fault Module Version: 2.28.8.0 Fault Module Timestamp: 4e253544
Exception Code: 40000015 Exception Offset: 0004c2d8 OS Version: 6.1.7600.2.0.0.272.7 Locale ID: 1033 Additional Information 1: 4a99 Additional Information 2: 4a99e4ac53bd5e60be05464c3d1a217e Additional Information 3: 794a
Additional Information 4: 794abc993e1c90d5202dd7b66fde9bb9

Any suggestions as to what might be going wrong?

share|improve this question
    
check the commit setting. you are probably loading up to much in memory before commit. –  Brad Nesom Feb 19 '13 at 13:42
    
where can I change the commit setting? –  michielz Feb 19 '13 at 13:50
add comment

1 Answer

The postgis documentation shows and example of piping in with sql chapter and section 4.3.1.
This site also mentions the -D switch for large datasets.
And here in the postgresql 9.2 documentation you can find more about the autocommit and checkpoint settings.
Inevitably someone else wil have a better answer.
I am sure many have overcome this in front of you.
Most of my experience is with oracle in this realm.
quick response to the comment made me post something to get you started.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.