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

Ondersteuning
1

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!

2

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

3

Hoi @NateDhaliwal, ja ik draai als root.

1 like
4

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;
1 like
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.