[Tile-serving] [osm2pgsql-dev/osm2pgsql] osm2pgsql-replication failed with different schema (Issue #2259)

[Sarah Hoffmann]

Your update command isn't going to work because the legacy pgsql output doesn't store its command line parameters in the properties table. You need to repeat them for the update run:

```
osm2pgsql-replication update -P 5435 -d gis --schema carto -- --cache 6144 --output pgsql --multi-geometry --merc --hstore --expire-tiles=10-19 --expire-output=/datengrab/osm/data/dirty_tiles --style carto.style --tag-transform-script carto.lua
```

We should be forwarding `--schema` though as `--schema`, it seems to end up as `--middle-schema` in the osm2pgsql command line.

Quick workaround for now: add `--schema carto` to the extra arguments, i.e. like this:

```
osm2pgsql-replication update -P 5435 -d gis --middle-schema carto -- --cache 6144 --output pgsql --multi-geometry --merc --hstore --expire-tiles=10-19 --expire-output=/datengrab/osm/data/dirty_tiles --style carto.style --tag-transform-script carto.lua --schema carto
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/issues/2259#issuecomment-2383468517
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/issues/2259/2383468517 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240930/154c6046/attachment-0001.htm>