[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql fails to create "osm_id" indexes on PostgreSQL 14 (Issue #1674)

[mboeringa]

I have now restarted the old PG13 cluster, and that shows the same empty "Location" field in pgAdmin, so this observation is likely insignificant and not relevant to the issue. I can also successfully import in the PG13 cluster, when using a small test dataset. 

The same when I use the PG14 cluster, it does finish, but processing is so quick that it is impossible to tell whether or not the intermediate "osm_id" column indexes were created or not. The final indexes on primary key and way are there though.

I did notice I had accidentally used an osm2pgsql flex style with 'public' schema as default instead of a custom schema when doing the large Planet import. I need to retry with a dedicated schema for the user and see if that fixes the issue.

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

Message ID: <openstreetmap/osm2pgsql/issues/1674/1126945745 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220515/58d544d6/attachment.htm>