prepare for 3.3.0 release

[nominatim.git] / docs / admin / Migration.md

diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md
index 2cc0b80b3cddcb867d1ad9a2c9d4a0be9f537eb3..0cfe29601fe1abeee03a1ac0bb34329353902e60 100644 (file)
--- a/docs/admin/Migration.md
+++ b/docs/admin/Migration.md
@@ -4,7 +4,43 @@ 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
 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 -> 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
 
 
 ## 3.1.0 -> 3.2.0
 


@@ -39,12 +75,18 @@ GRANT SELECT ON table country_osm_grid to "www-user";
 
 Replace the `www-user` with the user name of your website server if necessary.
 
 
 Replace the `www-user` with the user name of your website server if necessary.
 

-Finally, you can drop the now unused indexes:
+You can now drop the unused indexes:

 
 ```
 DROP INDEX idx_placex_reverse_geometry;
 ```
 
 
 ```
 DROP INDEX idx_placex_reverse_geometry;
 ```
 

+Finally, update all SQL functions:
+
+```sh
+./utils/setup.php --create-functions --enable-diff-updates --create-partition-functions
+```
+

 ## 3.0.0 -> 3.1.0
 
 ### Postcode Table
 ## 3.0.0 -> 3.1.0
 
 ### Postcode Table