Skip to content

Interlis Import unsupported startup parameter: options #76

@cymed

Description

@cymed

Describe the bug
When trying to import the any xtf, I received an psycopg2.OperationalError: connection to server at "%ip%", port %port% failed: FATAL: unsupported startup para

To Reproduce
Exact steps to reproduce the behavior:

  1. try to import the an xtf using the UI button
  2. See error

Expected behavior
XTF import

Screenshots / data
Error:

psycopg2.OperationalError: connection to server at "%ip%", port %port% failed: FATAL: unsupported startup parameter: options
Traceback (most recent call last):
File "C:\Users/%usr%/AppData/Roaming/QGIS/QGIS3\profiles\tww_dev/python/plugins\teksi_wastewater\teksi_wastewater_plugin.py", line 495, in actionImportClicked
self.interlisImporterExporter.action_import()
File "C:\Users/%usr%/AppData/Roaming/QGIS/QGIS3\profiles\tww_dev/python/plugins\teksi_wastewater\interlis\gui\interlis_importer_exporter.py", line 106, in action_import
raise exception
File "C:\Users/%usr%/AppData/Roaming/QGIS/QGIS3\profiles\tww_dev/python/plugins\teksi_wastewater\interlis\gui\interlis_importer_exporter.py", line 90, in action_import
self._action_import(xtf_file_input)
File "C:\Users/%usr%/AppData/Roaming/QGIS/QGIS3\profiles\tww_dev/python/plugins\teksi_wastewater\interlis\gui\interlis_importer_exporter.py", line 180, in _action_import
self._clear_ili_schema(recreate_schema=True)
File "C:\Users/%usr%/AppData/Roaming/QGIS/QGIS3\profiles\tww_dev/python/plugins\teksi_wastewater\interlis\gui\interlis_importer_exporter.py", line 478, in clear_ili_schema
connection = psycopg2.connect(
File "C:\Users%usr%\AppData\Roaming\Python\Python39\site-packages\psycopg2_init
.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: connection to server at "%ip%", port %port% failed: FATAL: unsupported startup parameter: options

Desktop (please complete the following information):

  • TEKSI plugin version: dev
  • TEKSI datamodel version: dev
  • TEKSI project file version: 2024_01_15
  • QGIS Version - see the About menu: 3.28.11
  • Postgres: 12.17
  • Postgis: POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 " PROJ="6.3.1" LIBXML="2.9.4" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.4.3 (Internal)"
  • OS: Windows

Additional context

  • psycopg2 Version: 2.9.7 (dt dec pq3 ext lo64)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions