Build-fout: geen toestemming om extensie "vector" te maken

AI-generated summary

yaxu encountered a build error while rebuilding their multisite Discourse install, specifically a “permission denied to create extension ‘vector’” error in PostgreSQL 15.13. Despite running as root and disabling plugins, the issue persisted. NateDhaliwal confirmed they were running as root, which yaxu affirmed. The problem was resolved by manually entering the PostgreSQL container via ./launcher enter app, switching to the postgres user, and executing CREATE EXTENSION IF NOT EXISTS vector; for each site’s database after restarting Docker yaxu. The root cause was that the discourse database user lacked superuser privileges needed to install the vector extension.

Hallo,

Ik heb problemen met het opnieuw opbouwen van mijn multisite Discourse-installatie. Ik krijg de onderstaande foutmeldingen.

  • Ik voer ./launcher rebuild app uit als root.
  • git status in /var/discourse zegt dat ik up-to-date ben met branch main.
  • het rapporteert dat postgres 15.13 draait:
    2025-08-14 10:35:04.390 UTC [45] LOG: starting PostgreSQL 15.13 (Debian 15.13-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
  • Ik heb alle plugins uitgeschakeld, behalve docker_manager.

Hier zijn de foutmeldingen:

I, [2025-08-14T10:35:56.213949 #1]  INFO -- : 
I, [2025-08-14T10:35:56.325831 #1]  INFO -- : 
I, [2025-08-14T10:35:56.325961 #1]  INFO -- : 
I, [2025-08-14T10:35:56.430781 #1]  INFO -- : 
I, [2025-08-14T10:35:56.431139 #1]  INFO -- : 
`/root` is niet schrijfbaar.
Bundler zal `/tmp/bundler20250814-776-hjo98w776` tijdelijk als uw home directory gebruiken.
2025-08-14 10:36:05.626 UTC [872] discourse@b_discourse ERROR:  permission denied to create extension "vector"
2025-08-14 10:36:05.626 UTC [872] discourse@b_discourse HINT:  Must be superuser to create this extension.
2025-08-14 10:36:05.626 UTC [872] discourse@b_discourse STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
2025-08-14 10:36:05.627 UTC [872] discourse@b_discourse ERROR:  current transaction is aborted, commands ignored until end of transaction block
2025-08-14 10:36:05.627 UTC [872] discourse@b_discourse STATEMENT:  SELECT 1 FROM pg_available_extensions WHERE name = 'vector';
2025-08-14 10:36:05.753 UTC [873] discourse@c_discourse ERROR:  permission denied to create extension "vector"
2025-08-14 10:36:05.753 UTC [873] discourse@c_discourse HINT:  Must be superuser to create this extension.
2025-08-14 10:36:05.753 UTC [873] discourse@c_discourse STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
2025-08-14 10:36:05.753 UTC [873] discourse@c_discourse ERROR:  current transaction is aborted, commands ignored until end of transaction block
2025-08-14 10:36:05.753 UTC [873] discourse@c_discourse STATEMENT:  SELECT 1 FROM pg_available_extensions WHERE name = 'vector';
2025-08-14 10:36:05.870 UTC [874] discourse@d_discourse ERROR:  permission denied to create extension "vector"
2025-08-14 10:36:05.870 UTC [874] discourse@d_discourse HINT:  Must be superuser to create this extension.
2025-08-14 10:36:05.870 UTC [874] discourse@d_discourse STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
2025-08-14 10:36:05.870 UTC [874] discourse@d_discourse ERROR:  current transaction is aborted, commands ignored until end of transaction block
2025-08-14 10:36:05.870 UTC [874] discourse@d_discourse STATEMENT:  SELECT 1 FROM pg_available_extensions WHERE name = 'vector';

Elke hulp/aanwijzingen worden zeer gewaardeerd!

Voer je dit uit als root-gebruiker (heb je sudo -s uitgevoerd hiervoor)?

Hoi @NateDhaliwal, ja ik draai als root.

Ik heb het opgelost in postgres (eerst moest ik docker opnieuw starten met service restart docker)

./launcher enter app
sudo -u postgres psql

vervolgens dit uitvoeren voor elke site database:

\c b_discourse
CREATE EXTENSION IF NOT EXISTS vector;