X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/a7e26e8f595eacb118abfe7ee0eaa3df4842e880..ec86a972a241754b66be0a31e73ca7ca27bc51de:/docs/admin/Migration.md?ds=sidebyside diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index 42aac9e7..0cfe2960 100644 --- a/docs/admin/Migration.md +++ b/docs/admin/Migration.md @@ -4,10 +4,22 @@ This page describes database migrations necessary to update existing databases to newer versions of Nominatim. SQL statements should be executed from the postgres commandline. Execute -`psql nominiatim` to enter command line mode. +`psql nominatim` to enter command line mode. -## 3.2.0 -> master +## 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 @@ -21,6 +33,14 @@ Finally, update all SQL functions: ./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