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

[TECHER Jean David]

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
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 11:40
  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 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/4771519f/attachment.html>