[gdal-dev] Problems loading swedish climate data to PostGIS

Bo Victor Thomsen bo.victor.thomsen at gmail.com
Tue Jun 23 14:39:04 PDT 2020


Thimo -

The ogr2ogr command from your reply contains an factual error:

thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr –f "PostgreSQL" 
-overwrite –progress --config PG_USE_COPY YES 
PG:"host='/var/run/postgresql' port='5432' dbname='sverige' 
user='sverige'" SCID_v4.0.gdb

should be:

thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr –f "PostgreSQL" 
-overwrite –progress --config PG_USE_COPY YES 
PG:"host='/var/run/postgresql' *port='6543*' dbname='sverige' 
user='sverige'" SCID_v4.0.gdb

Anther question: Has the postgresql user 'sverige' the necessary  
write/create rights to the database / schema ?

Den 23-06-2020 kl. 22:35 skrev Thiemo Kellner:
> thiemo @ thiemos-toshi /mnt/schweden % ogr2ogr –f "PostgreSQL" 
> -overwrite –progress --config PG_USE_COPY YES 
> PG:"host='/var/run/postgresql' port='5432' dbname='sverige' 
> user='sverige'" SCID_v4.0.gdb 
> HBVSv_intrans_HQloc100_rcp85_ensembleMean_diffPerc
> FAILURE:
> Unable to open datasource `PostgreSQL' with the following drivers.
>   -> `PCIDSK'
> ...
> # UNABLE TO USE ogr2ogr TO WRITE DATA TO MY PostGIS 

-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200623/2896d558/attachment.html>


More information about the gdal-dev mailing list