Cannot create Postgresql database
I am installing via the recommended method on the quickstart (sudo sh -c "$(curl -sSL https://get.funkwhale.audio/)"
). I am installing on an Ubuntu 19.04 lxc container which did not have Postgresql previously installed. However, I get the following error:
TASK [funkwhale : Create funkwhale database] **********************************************************************************************************************************************************************
An exception occurred during task execution. To see the full traceback, use -vvv. The error was: HINT: Use the same encoding as in the template database, or use template0 as template.
fatal: [127.0.0.1]: FAILED! => {"changed": false, "msg": "Database query failed: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)\nHINT: Use the same encoding as in the template database, or use template0 as template.\n"}
PLAY RECAP ********************************************************************************************************************************************************************************************************
127.0.0.1 : ok=5 changed=2 unreachable=0 failed=1 skipped=0 rescued=0 ignored=0
If I add template: template0
after this line, the error goes away and the playbook continues to install. (This suggestion comes from this Stack Overflow answer.) If this is an issue that others face, and if using template0
does not have any adverse effects, it may be a useful addition to the Ansible script.