unable to connect to database: FATAL: database \"funkwhale\" does not exist
Seems like I'm missing a database?
$> ansible-playbook -i inventory.ini playbook.yml --check --diff
[WARNING]: Invalid characters were found in group names but not replaced, use
-vvvv to see details
[DEPRECATION WARNING]: "include" is deprecated, use include_tasks/import_tasks
instead. This feature will be removed in version 2.16. Deprecation warnings can
be disabled by setting deprecation_warnings=False in ansible.cfg.
PLAY [funkwhale-servers] *******************************************************
TASK [Gathering Facts] *********************************************************
ok: [CENSURED@CENSURED]
TASK [funkwhale : set a password for postgresql DB (remote psql server only)] ***
skipping: [CENSURED@CENSURED]
TASK [funkwhale : Set frontend path] *******************************************
ok: [CENSURED@CENSURED]
TASK [funkwhale : Install system packages] *************************************
The following additional packages will be installed:
libjpeg-turbo8-dev libjpeg8-dev libmagic-mgc libmagic1 python3-appdirs
python3-distlib python3-filelock
Suggested packages:
file libssl-doc
The following NEW packages will be installed:
libffi-dev libjpeg-dev libjpeg-turbo8-dev libjpeg8-dev libldap2-dev
libmagic-dev libmagic-mgc libmagic1 libsasl2-dev libssl-dev
postgresql-client python3-appdirs python3-distlib python3-filelock
python3-virtualenv virtualenv
0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded.
changed: [CENSURED@CENSURED]
TASK [funkwhale : Install postgresql] ******************************************
ok: [CENSURED@CENSURED]
TASK [funkwhale : Start Postgresql] ********************************************
ok: [CENSURED@CENSURED]
TASK [funkwhale : Create funkwhale database user on CENSURED@CENSURED (local / passwordless)] ***
[WARNING]: Using world-readable permissions for temporary files Ansible needs
to create when becoming an unprivileged user. This may be insecure. For
information on securing this, see https://docs.ansible.com/ansible-
core/2.12/user_guide/become.html#risks-of-becoming-an-unprivileged-user
changed: [CENSURED]
TASK [funkwhale : Create funkwhale database user on (remote / with password)] ***
skipping: [CENSURED]
TASK [funkwhale : Create funkwhale database on CENSURED@CENSURED] **********
[WARNING]: Using world-readable permissions for temporary files Ansible needs
to create when becoming an unprivileged user. This may be insecure. For
information on securing this, see https://docs.ansible.com/ansible-
core/2.12/user_guide/become.html#risks-of-becoming-an-unprivileged-user
changed: [CENSURED]
TASK [funkwhale : set up pgsql extensions] *************************************
[WARNING]: Using world-readable permissions for temporary files Ansible needs
to create when becoming an unprivileged user. This may be insecure. For
information on securing this, see https://docs.ansible.com/ansible-
core/2.12/user_guide/become.html#risks-of-becoming-an-unprivileged-user
failed: [CENSURED@CENSURED] (item=unaccent) => {"ansible_loop_var": "myext", "changed": false, "msg": "unable to connect to database: FATAL: database \"funkwhale\" does not exist\n", "myext": "unaccent"}
failed: [CENSURED@CENSURED] (item=citext) => {"ansible_loop_var": "myext", "changed": false, "msg": "unable to connect to database: FATAL: database \"funkwhale\" does not exist\n", "myext": "citext"}
PLAY RECAP *********************************************************************
CENSURED@CENSURED : ok=7 changed=3 unreachable=0 failed=1 skipped=2 rescued=0 ignored=0