SOLUTION:
- SSH into your Yunohost server
- Switch to a superuser with
sudo su - Access Postgres as the superuser
sudo -u postgres psqlNote: I tried to do this as my normal user and it failed. - Once you’re in a Postgres command line, denoted by
postgres=#, you’re going to temporarily elevate the readeck database user to superuser status within the database. - To elevate the readeck database user to superuser, type
ALTER USER readeck SUPERUSER; - Wait for a minute or two while readeck discovers its newfound ability to create that ‘unaccent’ extension. Check Tools → Services in the admin web portal and you should see that the service has successfully initialized.
- Check the Readeck website and make sure you’re no longer getting the 502 error.
- Remove the superuser status by typing
ALTER USER readeck NOSUPERUSER; - You should be able to quit your Postgres command line with
exitand then typeexitagain to return your Yunohost root user back to your regular user. - Go back to the Readeck website and create your first user. You should be up and running now!