<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE>@font-face {
font-family: Courier;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
PRE {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Courier
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff size=2>Can
you send me your file in sql format ...at <A
href="mailto:davidtecher@yahoo.fr">davidtecher@yahoo.fr</A> ????</FONT></SPAN></DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff
size=2>Compress your file in .tar.gz or .tar.bz2 or zip</FONT></SPAN></DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff size=2>I will
try to load it if I can :-) with my own version of postgis
win32...</FONT></SPAN></DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=949023710-30082004><FONT face=Arial color=#0000ff size=2>then I
will give you the result I will have</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>TECHER JEAN DAVID<BR>- Responsable Informatique 01MAP
-<BR>e-mail:davidtecher@yahoo.fr<BR>Tél: 06 85 37 36 75<BR>Site PostGIS: <A
href="http://techer.pascal.free.fr/postgis/index.htm"
target=_blank>http://techer.pascal.free.fr/postgis/index.htm</A> </FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Message d'origine-----<BR><B>De :</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>De la part de</B>
Jeremy Palmer<BR><B>Envoyé :</B> lundi 30 août 2004
12:32<BR><B>À :</B>
postgis-users@postgis.refractions.net<BR><B>Objet :</B> [postgis-users]
Problems loading large geometry in postgis cvs 2004-08-20 postgresql 8.0b1
win32<BR><BR></FONT></DIV>
<DIV class=Section1><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Hi thanks for the reply. I just tried your suggestion; however that did not work either. I still<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">get the same result....<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">-----Original Message-----<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Hi<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">So that means that you have a postgresql server on linux and on postgresql<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">win32 too..<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">I think that you have already your table on linux ..;<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Instead of using SQL file or command why don't you try pg_dump for the two<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">servers:<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> pg_dump -h PGHOSTNAMELINUX -p PGPORTLINUX -U PGUSERNAMELINUX -W<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">PGPASSWORDLINUX -T YOURTABLE PGDATABASELINUX | psql -U PGUSERNAMEWIN32 -d<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">PGDATABASEWIN32<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">It should look like something like above....<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">TECHER JEAN DAVID<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">- Responsable Informatique 01MAP -<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">e-mail:<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">davidtecher at yahoo.fr</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Tel: 06 85 37 36 75<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Site PostGIS: <A href="http://techer.pascal.free.fr/postgis/index.htm">http://techer.pascal.free.fr/postgis/index.htm</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> -----Message d'origine-----<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> De : <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users-bounces at postgis.refractions.net</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">[mailto:<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users-bounces at postgis.refractions.net</A>]De la part de Jeremy<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">Palmer<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Envoye : lundi 30 aout 2004 11:40<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> A : <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">postgis-users at postgis.refractions.net</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Objet : [postgis-users] Problems loading large geometry in postgis cvs<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">2004-08-20 postgresql 8.0b1 win32<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Hi I'm having problems trying to load a very large WKT geometry (73, 000<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">points) into a win32 postgis database. I have tried loading this data into a<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">table in LINUX postgis server and I have had no problems.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> I can create the table and add the geometry columns ok, however when I try<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">to copy the data into the table (through SQL copy command) the server just<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">sits (well at for 20mins on a PIII 1Gzh) on the command maxing out the CPU<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">to 100%. Note I have loaded other geometry tables with fewer vertexes in the<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">win32 with no such problems.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> One other thing that I noticed is that I can not even open the WKT<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">geometry in a windows text editor (i.e. PFE, ultra edit, vedit); however I<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">can open the same file in kedit on Linux.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Is this a windows file limitation or a postgis problem in the win32<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt">build??<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Thanks<o:p></o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=Courier size=2><SPAN style="FONT-SIZE: 10pt"> Jeremy<o:p></o:p></SPAN></FONT></PRE>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>