Re: Regression from postgresql14 to postgresql17 with postgis (osm2pgsql)

Hi Elie,

> System is Ubuntu 24.10
> [...]
> files from https://planet.openstreetmap.org/pbf/
> Not working with postgresql17 :
>
> [USER@HOST ~]$ sudo pg_createcluster 17 osmdata --datadir=/mnt/faststorage/postgres --port=54372 --pgoption
autovacuum_work_mem='2GB'--pgoption checkpoint_completion_target='0.9' --pgoption checkpoint_timeout='60min' --pgoption
default_statistics_target='500'--pgoption effective_cache_size='10GB' --pgoption effective_io_concurrency='200'
--pgoptionmaintenance_work_mem='10GB' --pgoption min_wal_size='4GB' --pgoption max_connections='40' --pgoption
max_wal_size='12GB'--pgoption max_worker_processes='10' --pgoption max_parallel_workers_per_gather='6' --pgoption
max_parallel_workers='10'--pgoption max_parallel_maintenance_workers='4' --pgoption max_wal_senders='0' --pgoption
random_page_cost='1.0'--pgoption shared_buffers='1GB' --pgoption wal_buffers='16MB' --pgoption wal_level='minimal'
--pgoptionwork_mem='50MB' -- --data-checksums --lc-messages=C --auth-host=scram-sha-256 --auth-local=peer 

Your report is a bit difficult to read but if I understand correctly
you have a single pg_createcluster command that fails. Unfortunately
this is a 3rd party program which is not part of PostgreSQL
distribution. I found a web page that seems to contain emails of its
maintainers [1] but I recommend re-checking it with your local `man
pg_createcluster` or `pg_createcluster --help`.

From what I can tell you are basically trying to create a database
(a.k.a. cluster). I'm surprised to see that a 3rd party program is
needed for this. You may consider doing the same with the tools
provided by PostgreSQL. The documentation [2] will tell you how to do
this, or alternatively take a look at this script [3].

If you discover any problems with our tools and/or find a way to
reproduce your issue with them please let us know.

[1]: https://manpages.ubuntu.com/manpages/trusty/man8/pg_createcluster.8.html
[2]: https://www.postgresql.org/docs/
[3]: https://github.com/afiskon/pgscripts/blob/master/single-install.sh

--
Best regards,
Aleksander Alekseev