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

Thiemo Kellner thiemo at gelassene-pferde.biz
Tue Jun 23 16:56:45 PDT 2020


  Hei Bo

Well, I is just a project for myself so I made sverige superuser. :o)

Well again, I have on both ports PostGIS running but the 6543 has much  
much more space. 5432 is on a small SSD so  I moved from it to an  
externel HDD.

As mentionned in the previous post, Thomas was right. I copied options  
from the documentation PDF and unfortunately there it was not a dash.  
So fixing this, made it run perfectly well.

Takker for hjelp.

Hjertelig hilsen

Thiemo

Quoting Bo Victor Thomsen <bo.victor.thomsen at gmail.com>:

> 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 ?
  S/MIME Public Key:
https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200624/7923319c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4001 bytes
Desc: S/MIME Signature
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200624/7923319c/attachment-0001.bin>


More information about the gdal-dev mailing list