Content
View differences
Updated by Oliver Günther 7 months ago
* [ ] Bump database version for packages to 17
* [ ] Bump database service for docker-compose to 17
* [ ] add warning to release notes for both these cases and how to update
<br>
Need Code Maintenance (implementing a newer postgres version)
Current install routine from [https://www.openproject.org/docs/installation-and-operations/installation/packaged](https://www.openproject.org/docs/installation-and-operations/installation/packaged) für ubuntu 22.04 will auto install posgres 13 and shows a deprecated warning in future versions of this database. Maybe it's also in other setups analogue implemented.
This should be updated to postgres v17 or newer (maybe 18 has been released, if you develop this).
The apt package of ubuntu has already v17, you write in you promts that a newer version in future version is needed, so please update it in your setup routine ;)
See this in ssh terminal:
```text
DATABASE DEPRECATION WARNING
OpenProject versions higher than 16.0 will require at least PostgreSQL 17.
You can anticipate this upgrade by updating your database installation by following the guide at https://www.openproject.org/docs/installation-and-operations/misc/migration-to-postgresql17/
```
And there is an additional problem, it might be also solved with a maintanance by implementing a newer postgres version, showing at the end of setup routine:
```text
root@openproject:/tmp# sudo -u postgres createdb openproject -O openproject -E UTF8 --locale=de_DE.utf8
createdb: error: database creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: HINT: Use the same encoding as in the template database, or use template0 as template.
```
* [ ] Bump database service for docker-compose to 17
* [ ] add warning to release notes for both these cases and how to update
<br>
Need Code Maintenance (implementing a newer postgres version)
Current install routine from [https://www.openproject.org/docs/installation-and-operations/installation/packaged](https://www.openproject.org/docs/installation-and-operations/installation/packaged) für ubuntu 22.04 will auto install posgres 13 and shows a deprecated warning in future versions of this database. Maybe it's also in other setups analogue implemented.
This should be updated to postgres v17 or newer (maybe 18 has been released, if you develop this).
The apt package of ubuntu has already v17, you write in you promts that a newer version in future version is needed, so please update it in your setup routine ;)
See this in ssh terminal:
```text
DATABASE DEPRECATION WARNING
OpenProject versions higher than 16.0 will require at least PostgreSQL 17.
You can anticipate this upgrade by updating your database installation by following the guide at https://www.openproject.org/docs/installation-and-operations/misc/migration-to-postgresql17/
```
And there is an additional problem, it might be also solved with a maintanance by implementing a newer postgres version, showing at the end of setup routine:
```text
root@openproject:/tmp# sudo -u postgres createdb openproject -O openproject -E UTF8 --locale=de_DE.utf8
createdb: error: database creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:
```