Install : Database migration script fails to run

(Sorry I messed up with the Gitlab interface on this issue ^^")

Hello, I was following the installation documentation for Debian at https://docs.funkwhale.audio/installation/debian.html and I met a problem at the execution on the database migration script (python api/manage.py migrate).

Before this command, the documentation tells to install an extension on Postgres by executing:

sudo -u postgres psql funkwhale -c 'CREATE EXTENSION "unaccent";'

Then, the documentation tells to run in the venv and as the funkwhale the command:

python api/manage.py migrate

For me, this command failed:

(virtualenv) funkwhale@julie-funkwhale:~$ python api/manage.py migrate
[...]
django.db.utils.ProgrammingError: ERREUR:  droit refusé pour créer l'extension « unaccent »
HINT:  Doit être super-utilisateur pour créer cette extension.

Sentry is attempting to send 1 pending error messages
Waiting up to 10 seconds

The workaround I came up with was to execute this command in the venv as root. I run this script as root once and then the script runs correctly with the funkwhale user.

I think this should be fixed because this workaround could be unsafe (?).