Hi,
I've a question with the python API of gdal 3.11 new programs and
PostgreSQL driver.
I can run this in a terminal
gdal vector convert --overwrite base-cc-evol-struct-pop.csv
PG:"dbname='insee' port=5432 host='localhost' user='thomas'
password='xxxxxx' schemas='wip' tables='rp_population_import'"
and everything is working fine.
But if I try from the python API with
gdal.Run("vector", "convert", format="PostgreSQL", overwrite=True,
input="base-cc-evol-struct-pop.csv", output="dbname='insee' port=5432
host='localhost' user='thomas' password='xxxxxxxx' schemas='wip'
tables='rp_population_import'")
Python throw this error as if gdal/postgres actually try to create a new db:
ERROR 1: PostgreSQL driver doesn't currently support database creation.
Please create database with the `createdb' command.
ERROR 1: PostgreSQL driver failed to create dbname='insee' port=5432
host='localhost' user='thomas' password=XXXXXXXXXXXX schemas='wip'
tables='rp_population_import'
Traceback (most recent call last):
File "/home/thomas/repos_git/bd_insee/python/__main__.py", line 63,
in <module>
gdal.Run("vector", "convert", format="PostgreSQL", overwrite=True,
input="base-cc-evol-struct-pop.csv", output="dbname='insee' port=5432
host='localhost' user='thomas' password='xxxxxx' schemas='wip'
tables='rp_population_import'")
~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/thomas/miniforge3/envs/bd_insee/lib/python3.13/site-packages/osgeo/gdal.py",
line 3353, in Run
raise RuntimeError("Algorithm.Run() failed: %s" % GetLastErrorMsg())
RuntimeError: Algorithm.Run() failed: PostgreSQL driver failed to create
dbname='insee' port=5432 host='localhost' user='thomas'
password=XXXXXXXXXXXX schemas='wip' tables='rp_population_import'
Does anyone have a clue or it's me doing it bad ?
Thanks !
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
