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"

Installation

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
Facebook login was flagged as non compliant by Facebook after change to Let's Encrypt certificate system Support	14	771	November 26, 2021
Backup Failed error Support	5	58	May 8, 2025
Problem with postgres upgrade Installation	4	816	March 11, 2023
Install Discourse, change docker port 80 Installation unsupported-install , docker	15	14718	June 8, 2024
Error 500 on category page and homepage after upgrade to 2.6 Installation	15	898	September 26, 2020

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

Related topics