failed to create extension vector (pgvector): extension vector is unavailable

hey, i'm trying to start twenty on a server with the procedure documented here https://twenty.com/developers/section/self-hosting/docker-compose#Option%202:%20Manual%20steps

but i'm hitting the following issue on start:

worker-1                | Successfuly migrated DB!
worker-1                | touch: /app/docker-data/db_status: No such file or directory
db-1                    | 2025-01-08 20:32:17.366 GMT [338] ERROR:  extension "vector" is not available
db-1                    | 2025-01-08 20:32:17.366 GMT [338] DETAIL:  Could not open extension control file "/opt/bitnami/postgresql/share/extension/vector.control": No such file or directory.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] HINT:  The extension must first be installed on the system where PostgreSQL is running.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | query failed: CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | error: error: extension "vector" is not available
worker-1                | Failed to perform 'create extension "vector (pgvector)"': QueryFailedError: extension "vector" is not available

worker-1                | Successfuly migrated DB!
worker-1                | touch: /app/docker-data/db_status: No such file or directory
db-1                    | 2025-01-08 20:32:17.366 GMT [338] ERROR:  extension "vector" is not available
db-1                    | 2025-01-08 20:32:17.366 GMT [338] DETAIL:  Could not open extension control file "/opt/bitnami/postgresql/share/extension/vector.control": No such file or directory.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] HINT:  The extension must first be installed on the system where PostgreSQL is running.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | query failed: CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | error: error: extension "vector" is not available
worker-1                | Failed to perform 'create extension "vector (pgvector)"': QueryFailedError: extension "vector" is not available

worker-1                | Successfuly migrated DB!
worker-1                | touch: /app/docker-data/db_status: No such file or directory
db-1                    | 2025-01-08 20:32:17.366 GMT [338] ERROR:  extension "vector" is not available
db-1                    | 2025-01-08 20:32:17.366 GMT [338] DETAIL:  Could not open extension control file "/opt/bitnami/postgresql/share/extension/vector.control": No such file or directory.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] HINT:  The extension must first be installed on the system where PostgreSQL is running.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | query failed: CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | error: error: extension "vector" is not available
worker-1                | Failed to perform 'create extension "vector (pgvector)"': QueryFailedError: extension "vector" is not available

worker-1                | Successfuly migrated DB!
worker-1                | touch: /app/docker-data/db_status: No such file or directory
db-1                    | 2025-01-08 20:32:17.366 GMT [338] ERROR:  extension "vector" is not available
db-1                    | 2025-01-08 20:32:17.366 GMT [338] DETAIL:  Could not open extension control file "/opt/bitnami/postgresql/share/extension/vector.control": No such file or directory.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] HINT:  The extension must first be installed on the system where PostgreSQL is running.
db-1                    | 2025-01-08 20:32:17.366 GMT [338] STATEMENT:  CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | query failed: CREATE EXTENSION IF NOT EXISTS "vector"
worker-1                | error: error: extension "vector" is not available
worker-1                | Failed to perform 'create extension "vector (pgvector)"': QueryFailedError: extension "vector" is not available

full log: https://pastebin.com/GnqJky28

docker compose: https://pastebin.com/PgJh4s01

Pastebin

root@moonshot-1 /opt/docker/twenty # docker compose upWARN[0000] Th...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Pastebin

networks: proxy: external: true twenty:services: change-vol-o...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

failed to create extension vector (pgvector): extension vector is unavailable

Similar Threads

Similar Threads

Similar Threads