In Debian gibt es postgresql mittlerweile in Version 18 ("neben"
der Version 17).
Wenn ich die mit nominatim nutzen will, bekomme ich beim Import
(wiederholbar) diese Meldungen:
...
2025-10-19 13:52:32 Done postprocessing on table
'planet_osm_ways' in 2248s (37m 28s)
2025-10-19 13:54:55 Done postprocessing on table
'planet_osm_rels' in 142s (2m 22s)
2025-10-19 13:54:55 All postprocessing on table 'place' done in
489s (8m 9s).
2025-10-19 13:54:55 Storing properties to table
'"public"."osm2pgsql_properties"'.
2025-10-19 13:54:55 osm2pgsql took 7455s (2h 4m 15s) overall.
2025-10-19 13:54:55: Importing wikipedia importance data
2025-10-19 13:55:33: Importing secondary importance raster data
2025-10-19 13:55:33: Secondary importance file not imported.
Falling back to default ranking.
2025-10-19 13:55:33: Create functions (1st pass)
Traceback (most recent call last):
File "/srv/nominatim/nominatim-venv/bin/nominatim", line 5, in
<module>
exit(cli.nominatim())
~~~~~~~~~~~~~^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/cli.py",
line 244, in nominatim
return get_set_parser().run(cli_args=cli_args,
environ=environ)
~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/cli.py",
line 116, in run
return args.command.run(args)
~~~~~~~~~~~~~~~~^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/clicmd/setup.py",
line 82, in run
return asyncio.run(self.async_run(args))
~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.13/asyncio/runners.py", line 195, in run
return runner.run(main)
~~~~~~~~~~^^^^^^
File "/usr/lib/python3.13/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "/usr/lib/python3.13/asyncio/base_events.py", line 725, in
run_until_complete
return future.result()
~~~~~~~~~~~~~^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/clicmd/setup.py",
line 100, in async_run
self._base_import(args)
~~~~~~~~~~~~~~~~~^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/clicmd/setup.py",
line 181, in _base_import
self._setup_tables(args.config, args.reverse_only)
~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/clicmd/setup.py",
line 191, in _setup_tables
refresh.create_functions(conn, config, False, False)
~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/tools/refresh.py",
line 93, in create_functions
sql = SQLPreprocessor(conn, config)
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/db/sql_preprocessor.py",
line 91, in __init__
db_info['partitions'] = _get_partitions(conn)
~~~~~~~~~~~~~~~^^^^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/nominatim_db/db/sql_preprocessor.py",
line 25, in _get_partitions
for row in cur:
^^^
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/psycopg/cursor.py",
line 237, in __iter__
row = load(self._pos)
File
"/srv/nominatim/nominatim-venv/lib/python3.13/site-packages/psycopg/cursor.py",
line 234, in load
return self._tx.load_row(pos, self._make_row)
~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
File "psycopg_c/_psycopg/transform.pyx", line 500, in
psycopg_c._psycopg.Transformer.load_row
psycopg.InterfaceError: row must be included between 0 and 217
Weiß jemand eine "bessere" Möglichkeit, diese Fehler zu "umgehen",
als den "Rückschritt" auf postgresql Version 17 vorzunehmen?
Schöne Grüße Dieter
_______________________________________________
Talk-de mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/talk-de
