X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9afebddb16b09e09fa9a74624dcd79475b476f10..e8caf8d78d046008b7a951f6b1ba5d015dafb6bc:/docs/admin/Migration.md?ds=sidebyside diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md index 333c2477..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 @@ -37,8 +36,8 @@ functionality of each script: * ./utils/setup.php: `import`, `freeze`, `refresh` * ./utils/update.php: `replication`, `add-data`, `index`, `refresh` * ./utils/specialphrases.php: `special-phrases` -* ./utils/check_import_finished.php: `check-database` -* ./utils/warm.php: `warm` +* ./utils/check_import_finished.php: `admin` +* ./utils/warm.php: `admin` * ./utils/export.php: `export` Try `nominatim --help` for more information about each subcommand.