[Gdal-dev] SDE to PostgreSQL/PostGIS

Pål Kristensen pal.kristensen at statkart.no
Thu Jan 17 04:06:04 EST 2008


Hi!

Thanks! I assumed that it was something like that. The SDE plugin seems to
work correctly, but the problem is the PostgreSQL plugin that Howard Butler
compiled for me yesterday.

So, the solution would be to recompile the PostgreSQL plugin without debug
support?

Regards,
Pål Kristensen



mchapman wrote:
> 
> 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
> 
> _______________________________________________
> 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-tp14873585p14914870.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.



More information about the gdal-dev mailing list