Discourse fail to update

What app is this about, and its version: 3.5.0~ynh1
What YunoHost version are you running: 12.1.40.1 (stable)
What type of hardware are you using: VPS bought online

Describe your issue

I am trying to update Discourse with the yunohost admin interface, from 3.5.0~ynh1 to 2026.1.0~ynh1.

It seems that the database is missing information, but I do not know how to solve or bypass the backup process to update the version.

Share relevant logs or error messages

paste yunohost org raw feqarafoze
(I cannot directly put a link as I am a new member here)

Could you check that postgresql-15-pgvector exists on your system?

The error reminds me this issue Upgrade to v2026.1.0 failed, some tables not found · Issue #375 · YunoHost-Apps/discourse_ynh · GitHub

Indeed it was not there, and now the update works, thank you!

For people that may have the same issue, I have done this:

sudo apt install postgresql-15-pgvector

Error as it was not there and not available in the repo. Then:

apt update
apt install -y postgresql-common
sh -c "echo 'deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main' > /etc/apt/sources.list.d/pgdg.list"
apt install -y curl ca-certificates
curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
apt update
sudo apt install postgresql-15-pgvector