During the service restart I see the following error message in the logs
encountered during parsing of layer 'tunnels' in Layer at line 14780 of '/home/mapper/src/openstreetmap-carto/mapnik.xml'
** (process:14961): ERROR **: 03:32:49.011: An error occurred while loading the map layer 's2o': Postgis Plugin: ERROR: function carto_path_type(text, text) does not exist
LINE 15: ... 'highway_' || (CASE WHEN highway = 'path' THEN carto_path...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
in executeQuery Full sql was: 'SELECT * FROM (SELECT
Anybody else experienced this, I hope I did not skip any steps during the install
Looks good to me. As you state, functions.sql can be safely applied whether it has been previously executed or not.
It might be worth adding that failure to load the functions will result in errors like ERROR: function carto_path_type(text, text) does not exist so users can recognise what has gone wrong if they miss this step.
Actually, someone has pointed out another issue here - OSM Carto is in the process of switching over to using flex rather than pgsql output from osm2pgsql. To get to what was released on osm.org (tag 5.9.0) you need to do something like this:
That worked for me on a new Debian 12 system, and if no-one suggests a better way either here or at github I’ll change the other “up to date” guides too.