From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 6 Mar 2021 15:38:37 +0000 (+0100)
Subject: documentation for new migration command
X-Git-Tag: v3.7.0~21^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/3c9e09545e4a3955e0454097df9e5adcaa212d3d

documentation for new migration command
---

diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md
index dc94310b..52970a33 100644
--- a/docs/admin/Migration.md
+++ b/docs/admin/Migration.md
@@ -1,22 +1,21 @@
 # Database Migrations
 
-This page describes database migrations necessary to update existing databases
-to newer versions of Nominatim.
+Since version 3.7.0 Nominatim offers automatic migrations. Please follow
+the following steps:
 
-SQL statements should be executed from the PostgreSQL commandline. Execute
-`psql nominatim` to enter command line mode.
+* stop any updates that are potentially running
+* update Nominatim to the nwer version
+* goto your project directory and run `nominatim admin --migrate`
+* (optionally) restart updates
 
-## 3.6.0 -> master
-
-### Status table contains now time zone information
+Below you find additional migrations and hints about other structural and
+breaking changes.
 
-The `import_status` table has been changed to include timezone information
-with the time stamp. You need to alter an existing table before running
-any replication functions with:
+!!! note
+    If you are migrating from a version <3.6, then you still have to follow
+    the manual migration steps up to 3.6.
 
-```sql
-ALTER TABLE import_status ALTER COLUMN lastimportdate TYPE timestamp with time zone;
-```
+## 3.6.0 -> master
 
 ### New location for data files