X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/dd5cd9771315ec58fad4e3b04cab91a726a8c495..84d6b481ae58bf3e998959eb74639e24e99341ea:/docs/admin/Migration.md diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index be7d90ff..3e62d219 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -15,7 +15,7 @@ breaking changes. **Please read them before running the migration.** If you are migrating from a version <3.6, then you still have to follow the manual migration steps up to 3.6. -## 4.1.0 -> master +## 4.2.0 -> 4.3.0 ### New indexes for reverse lookup @@ -27,7 +27,7 @@ therefore either remove traffic from the machine before attempting a version update or create the index manually **before** starting the update using the following SQL: -``` +```sql CREATE INDEX IF NOT EXISTS idx_placex_geometry_reverse_lookupPlaceNode ON placex USING gist (ST_Buffer(geometry, reverse_place_diameter(rank_search))) WHERE rank_address between 4 and 25 AND type != 'postcode'