Twenty•3w ago

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

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.

5 Replies

ɃØĦɆᵾS•3w ago

Did you try using postgres-spilo container instead of postgres bitnami? https://hub.docker.com/r/twentycrm/twenty-postgres-spilo

peacOP•3w ago

i reverted to 0.32.2 (i intended to try 0.35.2 but it's late) and it worked, so it might be an actual bug. I'll give it a shot with postgres-spilo latest too

ɃØĦɆᵾS•3w ago

Postgres-spilo was introduced in 0.33.0 and it's a replacement for postgres bitnami so that's the reason of all your problems I'll update docs to make sure changes are properly documented

peacOP•3w ago

using 0.35.2 and postgres-spilo i get

server-1                | [Nest] 1  - 01/08/2025, 11:26:44 PM   ERROR [ExceptionHandler] pg_hba.conf rejects connection for host "172.21.0.4", user "twenty", database "default", no encryption

server-1                | [Nest] 1  - 01/08/2025, 11:26:44 PM   ERROR [ExceptionHandler] pg_hba.conf rejects connection for host "172.21.0.4", user "twenty", database "default", no encryption

ɃØĦɆᵾS•3w ago

Replace password with old one and should be working

Gaming

Programming

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

Did you find this page helpful?