<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>PgAdmin III is not designed for opening large sql
files. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>You should be using psql as you described - something
like below</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>psql -h someserver -d gisdb -U someuser -f
myshapefiles.sql</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2> 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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>Its generally easier to just copy the sql file to the
postgresql server and use the psql command line locally.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=010300214-19082008><FONT face=Arial
color=#0000ff size=2>Regina</DIV></FONT></SPAN><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Xiaoyu Guan<BR><B>Sent:</B> Tuesday, August 19, 2008 4:20 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
pgAdminIII crashes when import SQL<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Dear all:<BR>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.
<BR>Step 1. shp2pgsql. (win xp)<BR>shp2pgsql -s 4326 -i -I myshapefile.shp
myshapefile > myshapefile.sql<BR><BR>this step is work fine. I got two sql
files, one is over 445MB, another one is over 122MB. <BR><BR>Step 2. using query
tools in pgAdmin III . <BR>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.<BR><BR>some others. then I try to use psql command. <BR>psql -d mydatabase
-f myshapefiles.sql<BR><BR>then I am not sure how psql works. I can use QGIS
open the database, but not my GeoServer or uDig. <BR><BR>is there anyboday have
similar situations before?<BR><BR>All the best <BR><BR>Xiaoyu<BR><BR
clear=all><BR>-- <BR>Xiaoyu Guan (Sam)<BR>Geo-information Science<BR>Wageningen
UR<BR><BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>