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

[תמונה] Daniel Hooper: need to upgrade postgres from 10 We moved away from PostgreSQL 10 back in 2020 . I urge you to update as soon as possible.

Is there any guidance on how to do that? Is there more to it than reverting that app.yml line?

The link on my post is the guide on that, however we also moved to PostgreSQL 13 update so follow the new one.

This fixed it for me, and then I was able to upgrade postgres based on @Falco ’s instructions.

האתר מושבת לאחר עדכון כושל: נמנעה הרשאה ליצור הרחבה "unaccent"

תמיכה התקנה

Falco (Falco) 8 ביולי,‏ 2022,‏ 2:55pm 3

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

נושא		תגובות	צפיות
Update from 2.9.0 beta2 to beta4 failed (my site is down) Self-hosting	26	1829	11 ביוני,‏ 2022
Update problem : Broken Forum Self-hosting server-resources	27	2613	11 ביוני,‏ 2022
Failed to upgrade to v2.9.0beta3 Self-hosting	9	1085	22 במאי,‏ 2022
Failing update Self-hosting	35	594	25 בספטמבר,‏ 2025
Problem with upgrading the latest version Self-hosting	8	2892	22 ביולי,‏ 2020

האתר מושבת לאחר עדכון כושל: נמנעה הרשאה ליצור הרחבה "unaccent"

נושאים קשורים