[Gdal-dev] problem with ogr2ogr -f PostgreSQL...

Ethan Alpert ealpert at digitalglobe.com
Tue Mar 7 18:33:19 EST 2006


Actually you need PGB:  NOT PG8: 

I just dumped and inserted data using the CVS version of ogr with
postgres 8.1.3 and postgis 1.1.1

-e

-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Chapman,
Martin
Sent: Tuesday, March 07, 2006 4:07 PM
To: Thom DeCarlo; gdal-dev at lists.maptools.org
Subject: RE: [Gdal-dev] problem with ogr2ogr -f PostgreSQL...

Thom,

Also, you will have to modify ogr2ogr to pass the PG8: connection prefix
instead of PG:.  When I look at the old code I don't know how it ever
worked.  Basically because the PG: prefix was never being stripped off
the connect string before being passed to the PG driver, and the PG
driver doesn't like the PG: prefix.  Maybe in pre 8.x versions I would
ignore the prefix.

Martin

-----Original Message-----
From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Thom DeCarlo
Sent: Tuesday, March 07, 2006 3:22 PM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] problem with ogr2ogr -f PostgreSQL...

I've set up my PostGIS-enabled PostgreSQL database and created a dataset
called "spatial". I have several shapefiles that I want to load into a
single layer. I found the instructions on the gdal website but when I
specify a layername at the end of the ogr2ogr command it quietly fails.
That
is, no messages of any kind either at the command line nor in the pgsql
logfile. If I don't specify a layername the command works just fine.

Are there known problems with this function? I'm using PostGIS 1.1.0 and
PostgreSQL 8.1.1 on RHEL3.

Thanks,
Thom

--
Thom DeCarlo
-------------------------------------------------------
             Who is General Failure
         and why is he reading my disk?



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

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




More information about the Gdal-dev mailing list