[Tile-serving] [osm2pgsql-dev/osm2pgsql] Running my usual command now shows my version numbers then just quits. (Issue #2282)

[Jochen Topf]

That's correct. The log output is on stdout. The next line you should see in debug mode is `Found properties table 'osm2pgsql_properties': true.`. You didn't get that, so that narrows it down: Between the lines you are seeing and the lines you don't see, a bunch of database checks are done. They usually don't take any time at all. So I would suspect that something is different in RDS that in normal PostgreSQL.

Can you please re-run with `--log-sql` and show us the complete output?

You should see something like this:

```
2024-12-19 10:43:14  [00] osm2pgsql version 1.11.0 (1.11.0)
2024-12-19 10:43:14  [00] SQL: (C0) SELECT pg_backend_pid()
2024-12-19 10:43:14  [00] SQL: (C0) New database connection (context=check, backend_pid=1204916)
2024-12-19 10:43:14  [00] SQL: (C0) SET synchronous_commit = off
2024-12-19 10:43:14  [00] SQL: (C0) SELECT name, setting FROM pg_catalog.pg_settings
2024-12-19 10:43:14  [00] SQL: (C0) SELECT current_catalog
2024-12-19 10:43:14  [00] SQL: (C0) SELECT regexp_split_to_table(extversion, '\.') FROM pg_catalog.pg_extension WHERE extname='postgis'
2024-12-19 10:43:14  [00] Database version: 15.10 (Debian 15.10-0+deb12u1)
2024-12-19 10:43:14  [00] PostGIS version: 3.3
2024-12-19 10:43:14  [00] SQL: (C0) SELECT extname FROM pg_catalog.pg_extension WHERE true
2024-12-19 10:43:14  [00] SQL: (C0) SELECT nspname FROM pg_catalog.pg_namespace WHERE nspname !~ '^pg_' AND nspname <> 'information_schema'
2024-12-19 10:43:14  [00] SQL: (C0) SELECT spcname FROM pg_catalog.pg_tablespace WHERE spcname != 'pg_global'
2024-12-19 10:43:14  [00] SQL: (C0) SELECT amname FROM pg_catalog.pg_am WHERE amtype = 'i'
2024-12-19 10:43:14  [00] SQL: (C0) SELECT schemaname || '.' || tablename FROM pg_catalog.pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
2024-12-19 10:43:14  [00] Found properties table 'osm2pgsql_properties': true.
```

Check what's different in your case and run those queries by hand on the database and see what happens.

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

Message ID: <osm2pgsql-dev/osm2pgsql/issues/2282/2553233561 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241219/edb0b09c/attachment.htm>