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

[TECHER Jean David]

Can you send me your file in sql format ...at davidtecher at yahoo.fr ????

Compress your file in .tar.gz or .tar.bz2 or zip

I will try to load it if I can :-) with my own version of postgis win32...

then I will give you the result I will have

TECHER JEAN DAVID
- Responsable Informatique 01MAP -
e-mail:davidtecher at yahoo.fr
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
[mailto:postgis-users-bounces at postgis.refractions.net]De la part de Jeremy
Palmer
  Envoye : lundi 30 aout 2004 12:32
  A : postgis-users at postgis.refractions.net
  Objet : [postgis-users] Problems loading large geometry in postgis cvs
2004-08-20 postgresql 8.0b1 win32


Hi thanks for the reply. I just tried your suggestion; however that did not
work either. I stillget the same result.... -----Original Message----- Hi So
that means that you have a postgresql server on linux and on postgresqlwin32
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 twoservers:
 pg_dump -h PGHOSTNAMELINUX -p PGPORTLINUX -U
PGUSERNAMELINUX -WPGPASSWORDLINUX -T YOURTABLE PGDATABASELINUX | psql -U
PGUSERNAMEWIN32 -dPGDATABASEWIN32 It should look like something like
above.... TECHER JEAN DAVID- Responsable Informatique
01MAP -e-mail:davidtecher at yahoo.frTel: 06 85 37 36 75Site PostGIS:
http://techer.pascal.free.fr/postgis/index.htm   -----Message d'origine-----
De : postgis-users-bounces at
postgis.refractions.net[mailto:postgis-users-bounces at
postgis.refractions.net]De la part de JeremyPalmer  Envoye : lundi 30 aout
2004 11:40  A : postgis-users at postgis.refractions.net  Objet :
[postgis-users] Problems loading large geometry in postgis cvs2004-08-20
postgresql 8.0b1 win32    Hi I'm having problems trying to load a very large
WKT geometry (73, 000points) into a win32 postgis database. I have tried
loading this data into atable in LINUX postgis server and I have had no
problems.     I can create the table and add the geometry columns ok,
however when I tryto copy the data into the table (through SQL copy command)
the server justsits (well at for 20mins on a PIII 1Gzh) on the command
maxing out the CPUto 100%. Note I have loaded other geometry tables with
fewer vertexes in thewin32 with no such problems.     One other thing that I
noticed is that I can not even open the WKTgeometry in a windows text editor
(i.e. PFE, ultra edit, vedit); however Ican open the same file in kedit on
Linux.     Is this a windows file limitation or a postgis problem in the
win32build??     Thanks     Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040830/69f37845/attachment.html>