Upgrading via web UI failed with this error: INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' discourse@discourse ERROR: permission denied to create extension "unaccent" discourse@discourse HINT: Must be superuser to create this extension. discourse@discourse STA…

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;"'

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

Self-hosting support

Falco (Falco) July 8, 2022, 2:55pm 3

We moved away from PostgreSQL 10 back in 2020. I urge you to update as soon as possible.

3 Likes

Topic		Replies	Views
Update from 2.9.0 beta2 to beta4 failed (my site is down) Self-hosting support	26	1737	June 11, 2022
Update problem : Broken Forum Self-hosting support server-resources	27	2547	June 11, 2022
Failed to upgrade to v2.9.0beta3 Self-hosting support	9	1047	May 22, 2022
Failing update Self-hosting support	35	491	September 25, 2025
Problem with upgrading the latest version Self-hosting support	8	2843	July 22, 2020

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

Related topics