Using Docker All-in-One yields normal query results, but queries using a standalone PostgreSQL deployment are less accurate?

[wangchao732]

ALL in one query .

{
"place_id": 73561892,
"licence": "Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright",
"osm_type": "way",
"osm_id": 570417161,
"lat": "35.7334690",
"lon": "139.7861983",
"class": "amenity",
"type": "school",
"place_rank": 30,
"importance": 0.00000999999999995449,
"addresstype": "amenity",
"name": "荒川区立第三峡田小学校",
"display_name": "荒川区立第三峡田小学校, 明治通り, 荒川一丁目, 荒川, 荒川区, 東京都, 116-0000, 日本",
"address": {
"amenity": "荒川区立第三峡田小学校",
"road": "明治通り",
"neighbourhood": "荒川一丁目",
"quarter": "荒川",
"city": "荒川区",
"ISO3166-2-lvl4": "JP-13",
"postcode": "116-0000",
"country": "日本",
"country_code": "jp"
},
"boundingbox": [
"35.7331383",
"35.7340887",
"139.7856058",
"139.7865649"
]
}

External PostgreSQL on Docker.

{
"place_id": 63892057,
"licence": "Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright",
"osm_type": "way",
"osm_id": 362259072,
"lat": "35.7336856",
"lon": "139.7865676",
"class": "highway",
"type": "residential",
"place_rank": 26,
"importance": 0.0533433333333333,
"addresstype": "road",
"name": "",
"display_name": "荒川一丁目, 荒川, 荒川区, 東京都, 116-0000, 日本",
"address": {
"neighbourhood": "荒川一丁目",
"quarter": "荒川",
"city": "荒川区",
"ISO3166-2-lvl4": "JP-13",
"postcode": "116-0000",
"country": "日本",
"country_code": "jp"
},
"boundingbox": [
"35.7327310",
"35.7339096",
"139.7863157",
"139.7866639"
]
}

INFO: analyzing "public.location_road_229"
INFO: "location_road_229": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_230"
INFO: "location_road_230": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_237"
INFO: "location_road_237": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_239"
INFO: "location_road_239": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_240"
INFO: "location_road_240": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_241"
INFO: "location_road_241": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_242"
INFO: "location_road_242": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_243"
INFO: "location_road_243": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_244"
INFO: "location_road_244": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_245"
INFO: "location_road_245": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_246"
INFO: "location_road_246": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
INFO: analyzing "public.location_road_247"
INFO: "location_road_247": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
ANALYZE

sudo service postgresql stop
Stopping PostgreSQL 16 database server
...done.
rm /etc/postgresql/16/main/conf.d/postgres-import.conf
echo 'Deleting downloaded dumps in /nominatim'
Deleting downloaded dumps in /nominatim
rm -f '/nominatim/*sql.gz'
rm -f '/nominatim/*csv.gz'
rm -f /nominatim/tiger-nominatim-preprocessed.csv.tar.gz
'[' '' '!=' '' ']'
touch /var/lib/postgresql/16/main/import-finished
service postgresql start
Starting PostgreSQL 16 database server
...done.
cd /nominatim
sudo -E -u nominatim nominatim refresh --website --functions
2026-01-25 00:28:25: Using project directory: /nominatim
2026-01-25 00:28:25: Create functions
2026-01-25 00:28:29: WARNING: Website setup is no longer required. This function will be removed in future version of Nominatim.
'[' '' '!=' '' ']'
tailpid=12666
'[' false = true ']'
echo 'Skipping cache warmup'
'[' -z '' ']'
tail -Fv /var/log/postgresql/postgresql-16-main.log
Skipping cache warmup
++ nproc
==> /var/log/postgresql/postgresql-16-main.log <==
2026-01-25 00:28:19.549 UTC [38] LOG: shutting down
2026-01-25 00:28:19.590 UTC [38] LOG: checkpoint starting: shutdown immediate
2026-01-25 00:28:19.631 UTC [38] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.015 s, sync=0.001 s, total=0.082 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=96 kB; lsn=0/150A4F8, redo lsn=0/150A4F8
2026-01-25 00:28:19.706 UTC [37] LOG: database system is shut down
2026-01-25 00:28:20.478 UTC [12647] LOG: starting PostgreSQL 16.11 (Ubuntu 16.11-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
2026-01-25 00:28:20.508 UTC [12647] LOG: listening on IPv4 address "0.0.0.0", port 5432
2026-01-25 00:28:20.508 UTC [12647] LOG: listening on IPv6 address "::", port 5432
2026-01-25 00:28:20.565 UTC [12647] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-01-25 00:28:20.914 UTC [12650] LOG: database system was shut down at 2026-01-25 00:28:19 UTC
2026-01-25 00:28:21.060 UTC [12647] LOG: database system is ready to accept connections
Starting Gunicorn with 16 workers
--> Nominatim is ready to accept requests
GUNICORN_WORKERS=16
echo 'Starting Gunicorn with 16 workers'
echo '--> Nominatim is ready to accept requests'
cd /nominatim
sudo -E -u nominatim gunicorn --bind :8080 --pid /tmp/gunicorn.pid --workers 16 --daemon --enable-stdio-inheritance --worker-class uvicorn.workers.UvicornWorker nominatim_api.server.falcon.server:run_wsgi
wait
[2026-01-25 00:28:31 +0000] [12671] [INFO] Starting gunicorn 23.0.0
[2026-01-25 00:28:31 +0000] [12671] [INFO] Listening at: http://0.0.0.0:8080/ (12671)
[2026-01-25 00:28:31 +0000] [12671] [INFO] Using worker: uvicorn.workers.UvicornWorker
[2026-01-25 00:28:31 +0000] [12672] [INFO] Booting worker with pid: 12672
[2026-01-25 00:28:31 +0000] [12673] [INFO] Booting worker with pid: 12673
[2026-01-25 00:28:31 +0000] [12674] [INFO] Booting worker with pid: 12674
[2026-01-25 00:28:31 +0000] [12675] [INFO] Booting worker with pid: 12675
[2026-01-25 00:28:32 +0000] [12676] [INFO] Booting worker with pid: 12676
[2026-01-25 00:28:32 +0000] [12677] [INFO] Booting worker with pid: 12677
[2026-01-25 00:28:32 +0000] [12678] [INFO] Booting worker with pid: 12678
[2026-01-25 00:28:32 +0000] [12679] [INFO] Booting worker with pid: 12679
[2026-01-25 00:28:32 +0000] [12680] [INFO] Booting worker with pid: 12680
[2026-01-25 00:28:32 +0000] [12681] [INFO] Booting worker with pid: 12681
[2026-01-25 00:28:32 +0000] [12682] [INFO] Booting worker with pid: 12682
[2026-01-25 00:28:32 +0000] [12683] [INFO] Booting worker with pid: 12683
[2026-01-25 00:28:32 +0000] [12684] [INFO] Booting worker with pid: 12684
[2026-01-25 00:28:32 +0000] [12685] [INFO] Booting worker with pid: 12685
[2026-01-25 00:28:32 +0000] [12686] [INFO] Booting worker with pid: 12686
[2026-01-25 00:28:32 +0000] [12687] [INFO] Booting worker with pid: 12687
[2026-01-25 00:28:33 +0000] [12673] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12679] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12685] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12673] [INFO] Started server process [12673]
[2026-01-25 00:28:33 +0000] [12679] [INFO] Started server process [12679]
[2026-01-25 00:28:33 +0000] [12675] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12673] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12679] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12685] [INFO] Started server process [12685]
[2026-01-25 00:28:33 +0000] [12685] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12675] [INFO] Started server process [12675]
[2026-01-25 00:28:33 +0000] [12675] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12686] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12683] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12680] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12683] [INFO] Started server process [12683]
[2026-01-25 00:28:33 +0000] [12686] [INFO] Started server process [12686]
[2026-01-25 00:28:33 +0000] [12683] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12680] [INFO] Started server process [12680]
[2026-01-25 00:28:33 +0000] [12686] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12680] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12678] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12674] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12677] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12681] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12678] [INFO] Started server process [12678]
[2026-01-25 00:28:33 +0000] [12674] [INFO] Started server process [12674]
[2026-01-25 00:28:33 +0000] [12678] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12674] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12677] [INFO] Started server process [12677]
[2026-01-25 00:28:33 +0000] [12682] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12681] [INFO] Started server process [12681]
[2026-01-25 00:28:33 +0000] [12677] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12681] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12682] [INFO] Started server process [12682]
[2026-01-25 00:28:33 +0000] [12682] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12676] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12676] [INFO] Started server process [12676]
[2026-01-25 00:28:33 +0000] [12672] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12676] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12672] [INFO] Started server process [12672]
[2026-01-25 00:28:33 +0000] [12672] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12687] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12687] [INFO] Started server process [12687]
[2026-01-25 00:28:33 +0000] [12687] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12684] [WARNING] ASGI app factory detected. Using it, but please consider setting the --factory flag explicitly.
[2026-01-25 00:28:33 +0000] [12684] [INFO] Started server process [12684]
[2026-01-25 00:28:33 +0000] [12684] [INFO] Waiting for application startup.
[2026-01-25 00:28:33 +0000] [12679] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12673] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12682] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12678] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12680] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12677] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12685] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12686] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12675] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12683] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12687] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12674] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12684] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12676] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12681] [INFO] Application startup complete.
[2026-01-25 00:28:33 +0000] [12672] [INFO] Application startup complete.
2026-01-25 00:38:20.996 UTC [12648] LOG: checkpoint starting: time
2026-01-25 00:38:21.405 UTC [12648] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.020 s, sync=0.093 s, total=0.409 s; sync files=2, longest=0.050 s, average=0.047 s; distance=0 kB, estimate=0 kB; lsn=0/150A5E0, redo lsn=0/150A5A8
Theoretically, this issue should not occur. Is something misconfigured? What should I do?

[mtmail]

Is something misconfigured?

At this moment we know nothing about your configuration or which query you ran.

[wangchao732]

version: "3.8"

services:
postgres:
image: postgres:16
container_name: nominatim-db
restart: unless-stopped
shm_size: 2g
environment:
POSTGRES_USER: nominatim
POSTGRES_PASSWORD: "xxx"
POSTGRES_DB: nominatim
PGDATA: /var/lib/postgresql/data/pgdata
ports:
- "0.0.0.0:5432:5432"
volumes:
- /data/nominatim/pgdata:/var/lib/postgresql/data
- /data/nominatim/pglogs:/var/log/postgresql
- /data/nominatim/pgconf:/etc/postgresql/postgresql.conf.d
command: >
postgres
-c config_file=/etc/postgresql/postgresql.conf.d/my.conf
-c shared_buffers=1GB
-c effective_cache_size=4GB
-c maintenance_work_mem=512MB
-c checkpoint_completion_target=0.9
-c max_wal_size=4GB
-c wal_buffers=64MB
-c log_destination=stderr
-c logging_collector=on
-c log_directory=/var/log/postgresql
-c log_filename=%Y-%m-%d.log
-c log_rotation_age=1d
healthcheck:
test: ["CMD-SHELL", "pg_isready -U nominatim"]
interval: 10s
retries: 3

nominatim:
image: registry.cn-hongkong.aliyuncs.com/bcldops/nominatim:5.2
container_name: nominatim-app
restart: unless-stopped
depends_on:
postgres:
condition: service_healthy
shm_size: 2g
environment:
PBF_PATH: /nominatim/data/asia-latest.osm.pbf
IMPORT_STYLE: address
THREADS: 16
NOMINATIM_PASSWORD: "xxx"
NOMINATIM_FLATNODE_FILE: /nominatim/flatnode/flatnode.file
PGHOST: xxxx
PGUSER: nominatim
PGDATABASE: nominatim
PGPASSWORD: "xxx"
ports:
- "80:8080"
volumes:
- /data/nominatim/import:/nominatim/data
- /data/nominatim/flatnode:/nominatim/flatnode
- /data/nominatim/update:/nominatim/update
- /data/nominatim/logs:/var/log/nominatim
networks:
- nominatim-net

networks:
nominatim-net:
driver: bridge

Is something misconfigured?

At this moment we know nothing about your configuration or which query you ran.

[mtmail]

image: registry.cn-hongkong.aliyuncs.com/bcldops/nominatim:5.2

Is that the same image as mediagis? Is there documentation about this image?

[wangchao732]

@mtmail Postgres images is image: postgis/postgis:16-3.4

[wangchao732]

image: registry.cn-hongkong.aliyuncs.com/bcldops/nominatim:5.2

Is that the same image as mediagis? Is there documentation about this image?

yes, souce image mediagis/nominatim:5.2.

[mtmail]

Given the same input data, same software and a reverse search (coordinate search) both should return the same result.

You can add &debug=1 to the URL to see which database queries are run.

Does the school exist in the Nominatim database? Try nominatim lookup --osm_ids=W570417161 or equivalent URL

[wangchao732]

lookup

Debug output for get_places()

Parameters:

places
[OsmID(osm_type='W', osm_id=570417161, osm_class=None)]
details
LookupDetails(geometry_output=<GeometryFormat.NONE: 0>, address_details=True, linked_places=False, parented_places=False, entrances=False, keywords=False, geometry_simplification=0.0, query_stats=<nominatim_api.types.NoQueryStats object at 0x7f30d2597f80>)

[2026-01-27 02:54:26.300149]
Find in placex table

[2026-01-27 02:54:26.308032]
SELECT placex.place_id, placex.osm_type, placex.osm_id, placex.name, placex.class, placex.type, placex.admin_level, placex.address, placex.extratags, placex.housenumber, placex.postcode, placex.country_code, placex.importance, placex.wikipedia, placex.indexed_date, placex.parent_place_id, placex.rank_address, placex.rank_search, placex.linked_place_id, ST_AsEWKB(ST_Expand(placex.geometry, 0::INTEGER)) AS bbox, ST_AsEWKB(placex.centroid) AS centroid, CAST(anon_1.value ->> i::TEXT AS INTEGER) AS _idx FROM placex, json_array_elements([{'i': 0, 'oi': 570417161, 'oc': ''}]::JSON) AS anon_1 WHERE placex.osm_type = W::VARCHAR AND placex.osm_id = CAST(CAST((anon_1.value ->> oi::TEXT) AS VARCHAR) AS BIGINT) AND (CAST((anon_1.value ->> oc::TEXT) AS VARCHAR) = ::VARCHAR OR CAST((anon_1.value ->> oc::TEXT) AS VARCHAR) = placex.class) ORDER BY placex.class

[2026-01-27 02:54:26.370394]
Find in interpolation table

[2026-01-27 02:54:26.372569]
SELECT location_property_osmline.place_id, location_property_osmline.osm_id, location_property_osmline.parent_place_id, location_property_osmline.indexed_date, location_property_osmline.startnumber, location_property_osmline.endnumber, location_property_osmline.step, location_property_osmline.address, location_property_osmline.postcode, location_property_osmline.country_code, ST_AsEWKB(ST_Centroid(location_property_osmline.linegeo)) AS centroid, CAST(anon_1.value ->> i::TEXT AS INTEGER) AS _idx FROM location_property_osmline, json_array_elements([{'i': 0, 'oi': 570417161, 'oc': None}]::JSON) AS anon_1 WHERE location_property_osmline.osm_id = CAST(CAST((anon_1.value ->> oi::TEXT) AS VARCHAR) AS BIGINT) ORDER BY greatest(0::INTEGER, CAST((anon_1.value ->> oc::TEXT) AS INTEGER) - location_property_osmline.endnumber, location_property_osmline.startnumber - CAST((anon_1.value ->> oc::TEXT) AS INTEGER))

[2026-01-27 02:54:26.440187]
Find in postcode table

[2026-01-27 02:54:26.440257]
Find in tiger table