[postgis-users] Problems loading large geometry in postgis cvs 2004-08-20 postgresql 8.0b1 win32

[Jeremy Palmer]

Hi thanks for the reply. I just tried your suggestion; however that did not
work either. I still
get the same result....
 
-----Original Message-----
 
Hi
 
So that means that you have a postgresql server on linux and on postgresql
win32 too..
 
I think that you have already your table on linux ..;
 
Instead of using SQL file or command why don't you try pg_dump for the two
servers:
 
 pg_dump -h PGHOSTNAMELINUX -p PGPORTLINUX -U PGUSERNAMELINUX -W
PGPASSWORDLINUX -T YOURTABLE PGDATABASELINUX | psql -U PGUSERNAMEWIN32 -d
PGDATABASEWIN32
 
It should look like something like above....
 
TECHER JEAN DAVID
- Responsable Informatique 01MAP -
e-mail:davidtecher at yahoo.fr
<http://postgis.refractions.net/mailman/listinfo/postgis-users> 
Tel: 06 85 37 36 75
Site PostGIS: http://techer.pascal.free.fr/postgis/index.htm
 
  -----Message d'origine-----
  De : postgis-users-bounces at postgis.refractions.net
<http://postgis.refractions.net/mailman/listinfo/postgis-users> 
[mailto:postgis-users-bounces at postgis.refractions.net
<http://postgis.refractions.net/mailman/listinfo/postgis-users> ]De la part
de Jeremy
Palmer
  Envoye : lundi 30 aout 2004 11:40
  A : postgis-users at postgis.refractions.net
<http://postgis.refractions.net/mailman/listinfo/postgis-users> 
  Objet : [postgis-users] Problems loading large geometry in postgis cvs
2004-08-20 postgresql 8.0b1 win32
 
 
  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.
 
 
 
  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.
 
 
 
  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.
 
 
 
  Is this a windows file limitation or a postgis problem in the win32
build??
 
 
 
  Thanks
 
 
 
  Jeremy

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040830/61163d7d/attachment.html>