Site down after failed update: permission denied to create extension "unaccent"

How was this server installed?

Have you made any changes to the Postgres configuration?

If you’re still on Postgres 10 try adding this after the hooks: section in your app.yml:


after_postgres:
    - exec: su postgres -c 'psql discourse -c "create extension if not exists unaccent;"'