I saw that i should use FWTOOLS to get the postgres driver and then I tried this without any success: ogr2ogr -f "PostgreSQL" PG:"host=localhost dbname=testgis user=cvfc PG:passwd=pwd" gltp:/vrf/test/vmap/v0eur_5/vmaplv0/eurnasia -lco OVERWRITE=yes -nln polbndl_bnd 'polb...@bnd(*)_line'<mailto:'polb...@bnd(*)_line'>
ERROR 1: PQconnectdb failed. invalid connection option "PG:passwd" ERROR 1: PostgreSQL driver doesn't currently support database creation. Please create database with the `createdb' command. PostgreSQL driver failed to create PG:host=localhost dbname=testgis user=postgres PG:passwd=postgrespwd Kind regards, Paul ________________________________ From: sophia parafina [mailto:[email protected]] Sent: den 16 mars 2009 17:05 To: Malm Paul Cc: gdal-dev Subject: Re: [gdal-dev] ogr2ogr VPF->postgis slashes are incorrect, e.g. gltp:[//<hostname>]/<driver_name>/<dataset_name>:<layer_name>:<family> On Mon, Mar 16, 2009 at 11:38 AM, Malm Paul <[email protected]<mailto:[email protected]>> wrote: Hi! I'm trying to read in VPF data to my postgreSQL/PostGis database with ogr2ogr.exe in WinXP The lht file is placed in c:\test\vmap\v0eur_5\vmaplv0\eurnasia The database is called testgis This is what I typed in on the command prompt: ogr2ogr -f PostgreSQL PG:"dbname='testgis' user='cvfc' passwd='pwd'" gltp:\vrf\test\vmap\v0eur_5\vmaplv0\eurnasia -lco OVERWRITE=yes -nln polbndl_bnd 'polb...@bnd(*)_line' This is what I got: FAILURE: Unable to open datasource `gltp:\vrftest\vmap\v0eur_5\vmaplv0\eurnasia' with the following drivers. -> ESRI Shapefile -> MapInfo File -> UK .NTF -> SDTS -> TIGER -> S57 -> DGN -> VRT -> REC -> Memory -> BNA -> CSV -> GML -> GPX -> KML -> GeoJSON -> GMT -> ODBC -> PGeo -> AVCBin What have I missed? Is it possible to load all featuretypes in a Postgis database at once? Kind regards, Paul_______________________________________________ gdal-dev mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
