PgAdmin III is not designed for opening large sql files. You should be using psql as you described - something like below psql -h someserver -d gisdb -U someuser -f myshapefiles.sql If you are not local to the server, you need to specific the host name too and run the above from a command line and preferably specify the name of the user you are connecting as. If you don't have trust between the server and pc you are on - you will be prompted for password. Its generally easier to just copy the sql file to the postgresql server and use the psql command line locally. Hope that helps, Regina
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Xiaoyu Guan Sent: Tuesday, August 19, 2008 4:20 AM To: [email protected] Subject: [postgis-users] pgAdminIII crashes when import SQL Dear all: Here I have some problems with pgAdminIII. I am not a PostGIS export,(neither SQL). but I still want to use PostGIS. I have two ESRI shapefiles. each file have many attribute. here is some steps what I did. Step 1. shp2pgsql. (win xp) shp2pgsql -s 4326 -i -I myshapefile.shp myshapefile > myshapefile.sql this step is work fine. I got two sql files, one is over 445MB, another one is over 122MB. Step 2. using query tools in pgAdmin III . crashes happpens when I am opening the two sql file in query tools of my database. my pc is Intel Core Dual, 2GB ram, then XP warning is that some memory(0x00b45d2c) could not be writen. I attached screen shot. some others. then I try to use psql command. psql -d mydatabase -f myshapefiles.sql then I am not sure how psql works. I can use QGIS open the database, but not my GeoServer or uDig. is there anyboday have similar situations before? All the best Xiaoyu -- Xiaoyu Guan (Sam) Geo-information Science Wageningen UR ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
