search

zammad / zammad-docker-compose

Zammad Docker images for docker-compose
https://hub.docker.com/r/zammad/zammad-docker-compose/
GNU Affero General Public License v3.0
273 stars 223 forks source link

postgresql upgrade 9.6 to 15.3 #361

Closed technoicon closed 1 year ago

technoicon commented 1 year ago

Infos

Expected behavior

Update from 5.2 to 6.0. postgresql upgrade 9.6 to 15.3 Expect the database to be updated to the new version.

Actual behavior

error in postgresql logs: 2023-07-10 15:36:15.085 UTC [1] FATAL: database files are incompatible with server 2023-07-10 15:36:15.085 UTC [1] DETAIL: The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 15.3.

Steps to reproduce the behavior

Not sure, install postgresql 9.6, then try to update to v6.0 of zammad.

I have bypassed this by changing the database version in the .env file to 9.6.

(PS: I'm having the storage issue as well, but that is another issue, i believe.

technoicon commented 1 year ago

found upgrade instructions. https://github.com/zammad/zammad-docker-compose/releases/tag/v6.0.0