<!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>@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
}
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=580065009-30082004><FONT face=Arial color=#0000ff
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff size=2>So
that means that you have a postgresql server on linux and on postgresql win32
too..</FONT></SPAN></DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff size=2>I
think that you have already your table on linux ..;</FONT></SPAN></DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2>Instead of using SQL file or command why don't you try pg_dump for the
two servers:</FONT></SPAN></DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2> pg_dump -h PGHOSTNAMELINUX -p PGPORTLINUX -U
PGUSERNAMELINUX -W PGPASSWORDLINUX -T YOURTABLE PGDATABASELINUX | psql -U
PGUSERNAMEWIN32 -d PGDATABASEWIN32</FONT></SPAN></DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=580065009-30082004><FONT face=Arial color=#0000ff size=2>It
should look like something like above....</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
11:40<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>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi I’m having problems trying to
load a very large WKT geometry (73, 000 points) into a win32 postgis database.
I have tried loading this data into a table in LINUX postgis server and I have
had no problems. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I can create the table and add the
geometry columns ok, however when I try to copy the data into the table
(through SQL copy command) the server just sits (well at for 20mins on a PIII
1Gzh) on the command maxing out the CPU to 100%. Note I have loaded other
geometry tables with fewer vertexes in the win32 with no such
problems.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">One other thing that I noticed is
that I can not even open the WKT geometry in a windows text editor (i.e. PFE,
ultra edit, vedit); however I can open the same file in kedit on Linux.
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is this a windows file limitation
or a postgis problem in the win32 build??<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jeremy<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>