[Gdal-dev] SDE to PostgreSQL/PostGIS

[Martin Chapman]

Whoops, from the image looks like your application or the plugin is compiled with the debug version and it doesn't like the different heap space.

Martin Chapman
Chief Software Architect
Fortified Datacom Inc.
http://www.fortifieddatacom.com
mchapman at fortifieddatacom.com
303-324-1065


-----Original Message-----
From: gdal-dev-bounces at lists.osgeo.org [mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of Pål Kristensen
Sent: Thursday, January 17, 2008 1:29 AM
To: gdal-dev at lists.osgeo.org
Subject: Re: [Gdal-dev] SDE to PostgreSQL/PostGIS


Hi!

Thanks for the help! Unfortunately there seems to be something wrong. I got
the attached error message when executing the following command:

SET PG_USE_COPY=YES
ogr2ogr -nlt LINESTRING -nln n50_bilveg -lco GEOMETRY_NAME=the_geom -a_srs
EPSG:32633 -f PostgreSQL PG:"dbname=kartdata user=xxx host=xx.xx.xx.xx"
SDE:xx.xx.xx.xx,5157,,n50,n50,n50.bilveg

http://www.nabble.com/file/p14914348/ogr2ogr_error.png 

Do you know what is causing this?

Ogrinfo --formats however shows both SDE and PostgreSQL support.


Regards
Pål Kristensen



Howard Butler-3 wrote:
> 
> I have placed a PostGIS plugin on the download page.  Please confirm  
> that it works for you...
> 
> http://download.osgeo.org/gdal/win32/1.5/
> 
> Howard
> 
> On Jan 16, 2008, at 2:12 AM, Pål Kristensen wrote:
> 
>>
>> Hi!
>>
>> I'm trying to convert some data (approx 10GB) from SDE to PostgreSQL/ 
>> PostGIS
>> using ogr2ogr. Due to the large amount of data it's not practical to  
>> use
>> shapefiles as intermediate storage. The problem is that I can't find  
>> any
>> GDAL/OGR windows binaries with both SDE support and PostgreSQL  
>> support.
>>
>> The windows binaries which you can download form
>> http://download.osgeo.org/gdal/win32/1.5/ does support SDE 9.x, by  
>> using the
>> plugins available at the same link. However these win binaries does,  
>> for
>> some reason, not support PostgreSQL.
>>
>> I then tried to use the latest FWtools (2.0.4) that has PostgreSQL  
>> support,
>> but I cant find any SDE plugins that works with newer FWtools than  
>> version
>> 1.3.9.
>>
>> So basically FWtools works with PostgreSQL and the win32 binaries  
>> from the
>> GDAL web site works with SDE.
>>
>> Is there any win32 compilation of the latest gdal 1.5.0 that has both
>> PostgreSQL and SDE 9.x support??
>>
>> Regards,
>> Pål Kristensen
>> -- 
>> View this message in context:
>> http://www.nabble.com/SDE-to-PostgreSQL-PostGIS-tp14873585p14873585.html
>> Sent from the GDAL - Dev mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> 
> 

-- 
View this message in context: http://www.nabble.com/SDE-to-PostgreSQL-PostGIS-tp14873585p14914348.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev