[Tile-serving] [openstreetmap/osm2pgsql] Is it compatible with Citus? (Discussion #1926)

[Jochen Topf]

> We are trying to use it with Citus DB (distributed PG), but its dropping already distributed tables and recreating them.

I don't now Citus, but from your description it could have something to do with the (pseudo-)clustering feature of osm2pgsql. By default osm2pgsql first creates UNLOGGED tables, then later sorts the data and copies it into a new table. The temporary table is removed and the new table renamed. It might be that Citus doesn't work well with that UNLOGGED table. You can disable this feature by setting `cluster = 'no'` in your table definitions in the flex output. See https://osm2pgsql.org/doc/manual.html#clustering-by-geometry .

> Is there a way to run distribution commands in a post script?

I don't know that "distribution commands" are. If you simply want to run a command after osm2pgsql has run, wrap it in a shell script and run the command from there. If you need something else, describe in more detail what you need.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/1926#discussioncomment-5089413
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1926/comments/5089413 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230223/5089ca57/attachment.htm>