Nemskiller007
IImmich
•Created by Nemskiller007 on 5/22/2025 in #help-desk-support
Failed to activate VectorChord extension. Please ensure the Postgres instance has VectorChord in
It works now
8 replies
IImmich
•Created by Nemskiller007 on 5/22/2025 in #help-desk-support
Failed to activate VectorChord extension. Please ensure the Postgres instance has VectorChord in
Alright the command line have to be remove
8 replies
IImmich
•Created by Nemskiller007 on 5/22/2025 in #help-desk-support
Failed to activate VectorChord extension. Please ensure the Postgres instance has VectorChord in
And this is my docker-compose.yml for the database :
database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
POSTGRES_INITDB_ARGS: '--data-checksums'
# Uncomment the DB_STORAGE_TYPE: 'HDD' var if your database isn't stored on SSDs
# DB_STORAGE_TYPE: 'HDD'
volumes:
# Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
- ${DB_DATA_LOCATION}:/var/lib/postgresql/data
restart: always
command: ["postgres", "-c" ,"shared_preload_libraries=vectors.so", "-c", 'search_path="$$user", public, vectors', "-c", "logging_collector=on", "-c", "max_wal_size=2GB", "-c", "shared_buffers=512MB", "-c", "wal_compression=on"]
8 replies