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
Problem with postgres upgrade Installation	4	784	March 11, 2023
Rebuild fails on db:migrate w/PG12 Installation	18	1883	December 31, 2022
Error upgrading, failed to bootstrap Installation	21	1693	April 25, 2022
Urgent, upgraded build failed UniqueViolation Installation	24	1504	February 20, 2021
Update from 2.9.0 beta2 to beta4 failed (my site is down) Installation	26	1571	June 11, 2022

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

Related Topics