If by a pop-up saying "PostgreSQL Tools has stopped RESPONDING", it may be the shear size of your file. On windows, I have observed such a phenomenon when trying to import fairly large postgresql files (the size of yours ranks up there as fairly large).
To verify if this was the cause, excerpt your file, extracting the first 20 or so inserts and see if that will run successfully. If so, you can try ignorning the "not responding" message and hope that it completes, or split the file manually, or by some other means into several smaller files. HTH, r.b. ________________________________________ From: postgis-users-boun...@postgis.refractions.net [postgis-users-boun...@postgis.refractions.net] on behalf of JamesH [james.hol...@newcastle.ac.uk] Sent: Thursday, April 19, 2012 11:05 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Raster import is causing Postgres to close "When you say " I open the sql file in Postgres ", what do you mean exactly? How do you load the file in the db?" In the SQL query window for the database, I select File > Open and then select the sql file. Normally, once I've done this the code displays in the window and I then Execute the query to create the new table. "Any error message?" Yes, a pop-up that says 'pgAdmin III - PostgreSQL Tools has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.' James ----- GIS Undergraduate -- View this message in context: http://postgis.17.n6.nabble.com/Raster-import-is-causing-Postgres-to-close-tp4897915p4898506.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
