[postgis-users] Raster import is causing Postgres to close

[Burgholzer, Robert (DEQ)]

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-bounces at postgis.refractions.net [postgis-users-bounces at postgis.refractions.net] on behalf of JamesH [james.holmes at newcastle.ac.uk]
Sent: Thursday, April 19, 2012 11:05 AM
To: postgis-users at 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users