Missing UK postcodes after full import

[RailsGuy]

I've just installed nominatim 4.5.0 and performed a full planet import with UK postcodes but many postcodes are missing.

My import cmd and log is below. Have I made errors in my import or missed something?

For example a search on public nominatim.openstreetmap.org returns the expected result but on my server nothing is found
https://nominatim.openstreetmap.org/ui/search.html?q=RG457HP

Looking at the debug information I can see this is found in the word table but on my database nothing is found in word.

SELECT word.word_id, word.word_token, word.type, word.word, word.info
FROM word
WHERE word.word_token IN (['rg457hp'])

type	token	word_token	lookup_word	penalty	count	info
POSTCODE	None	rg457hp	RG45 7HP	0.0	1	None

This was my import environment

~/nominatim-planet$ ls -l
total 83073528
-rw-rw-r-- 1 ### ###    13922962 Aug  7 08:57 gb_postcodes_with_ni.csv.gz
-rw-rw-r-- 1 ### ### 82843220187 Oct 11 21:58 planet-latest.osm.pbf
-rw-rw-r-- 1 ### ###     3872892 Oct 16 19:14 screenlog.0
-rw-rw-r-- 1 ### ###  1812267601 Nov 24  2023 tiger-nominatim-preprocessed-latest.csv.tar.gz
-rw-rw-r-- 1 ### ###      402488 Nov 24  2023 us_postcodes.csv.gz
-rw-rw-r-- 1 ### ###   393574858 Nov 17  2019 wikimedia-importance.sql.gz

~/nominatim-planet$ nominatim import --osm-file planet-latest.osm.pbf 2>&1 | tee planet_import.log
2024-10-16 19:15:26: Using project directory: /home/######/nominatim-planet
2024-10-16 19:15:28: Creating database
2024-10-16 19:15:29: Setting up country tables
2024-10-16 19:15:29: Importing OSM data file
2024-10-16 19:15:29  osm2pgsql version 1.11.0
2024-10-16 19:15:29  Database version: 14.13 (Ubuntu 14.13-0ubuntu0.22.04.1)
2024-10-16 19:15:29  PostGIS version: 3.2
2024-10-16 19:15:29  Storing properties to table '"public"."osm2pgsql_properties"'.
Processing: Node(6160k 770.0k/s) Way(0k 0.00k/s) Relation(0 0.0/s)
...

2024-10-20 00:19:32: Done 0/0 in 0 @ 0.000 per second - FINISHED rank 0
2024-10-20 00:19:32: Starting interpolation lines (location_property_osmline) (using batch size 20)
2024-10-20 00:19:33: Done 0/0 in 0 @ 0.000 per second - FINISHED interpolation lines (location_property_osmline)
2024-10-20 00:19:33: Starting indexing postcodes using 6 threads
2024-10-20 00:19:33: Starting postcodes (location_postcode) (using batch size 20)
2024-10-20 00:19:34: Done 0/0 in 0 @ 0.000 per second - FINISHED postcodes (location_postcode)
2024-10-20 00:19:35: Post-process tables
2024-10-20 02:05:17: Create search index for default country names.
2024-10-20 02:05:50: Recompute word counts
2024-10-20 02:31:26: Setup website at /home/#####/nominatim-planet/website

[mtmail]

During import Nominatim looks for $COUNTRYCODE_postcodes.csv files (and .csv.gz). https://nominatim.org/release-docs/4.5/admin/Import/#external-postcodes

The postcodes from the CSV files get imported into the location_postcodes database table.

1. Rename your gb_postcodes_with_ni.csv.gz to gb_postcodes.csv.gz.

2. Run nominatim refresh --postcodes inside the project directory (it's not very fast, 1 hour I think) https://nominatim.org/release-docs/4.5/customize/Postcodes/

Then postcode search should work.

[RailsGuy]

Yes that worked thank you