SQL statements should be executed from the PostgreSQL commandline. Execute
`psql nominatim` to enter command line mode.
-## 3.4.0 -> master
+## 3.5.0 -> master
+
+### Switching to dotenv
+
+As part of the work changing the configuration format, the configuration for
+the website is now using a separate configuration file. To create the
+configuration file, run the following command after updating:
+
+```sh
+./utils/setup.php --setup-website
+```
+
+## 3.4.0 -> 3.5.0
### New Wikipedia/Wikidata importance tables
The last step takes about 10 hours on the full planet.
+Remove one function (it will be recreated in the next step):
+
+```sql
+DROP FUNCTION create_country(hstore,character varying);
+```
+
+Finally, update all SQL functions:
+
+```sh
+./utils/setup.php --create-functions --enable-diff-updates --create-partition-functions
+```
+
## 3.3.0 -> 3.4.0
### Reorganisation of location_area_country table
CREATE INDEX idx_location_area_country_place_id ON location_area_country USING BTREE (place_id);
```
+Finally, update all SQL functions:
+
+```sh
+./utils/setup.php --create-functions --enable-diff-updates --create-partition-functions
+```
+
## 3.2.0 -> 3.3.0
### New database connection string (DSN) format