X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/e28fa6c7875b0a9a5d4c5e86abcd602040a26e68..ec86a972a241754b66be0a31e73ca7ca27bc51de:/docs/admin/Migration.md diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index c291ae49..0cfe2960 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -6,6 +6,42 @@ to newer versions of Nominatim. SQL statements should be executed from the postgres commandline. Execute `psql nominatim` to enter command line mode. + +## 3.2.0 -> 3.3.0 + +### New database connection string (DSN) format + +Previously database connection setting (`CONST_Database_DSN` in `settings/*.php`) had the format + + * (simple) `pgsql://@/nominatim` + * (complex) `pgsql://johndoe:secret@machine1.domain.com:1234/db1` + +The new format is + + * (simple) `pgsql:dbname=nominatim` + * (complex) `pgsql:dbname=db1;host=machine1.domain.com;port=1234;user=johndoe;password=secret` + +### Natural Earth country boundaries no longer needed as fallback + +``` +DROP TABLE country_naturalearthdata; +``` + +Finally, update all SQL functions: + +```sh +./utils/setup.php --create-functions --enable-diff-updates --create-partition-functions +``` + +### Configurable Address Levels + +The new configurable address levels require a new table. Create it with the +following command: + +```sh +./utils/update.php --update-address-levels +``` + ## 3.1.0 -> 3.2.0 ### New reverse algorithm