PGVector Store error - extension "vector" is not available

Questions
7

Here’s what worked for me

volumes:
  pgvector_storage:

networks:
  demo:

services:
  pgvector:
    image: ankane/pgvector
    networks: ['demo']
    container_name: pgvector
    ports:
     - 5555:5432
    restart: always
    environment:
      - POSTGRES_DB=vectordb
      - POSTGRES_USER=admin
      - POSTGRES_PASSWORD=password
      - POSTGRES_HOST_AUTH_METHOD=trust
    volumes:
     - ./pgvector-init.sql:/docker-entrypoint-initdb.d/init.sql
     - pgvector_storage:/var/lib/postgresql/data

The content of pgvector-init.sql:

CREATE EXTENSION IF NOT EXISTS vector;

CREATE TABLE IF NOT EXISTS embeddings (
  id SERIAL PRIMARY KEY,
  embedding vector,
  text text,
  created_at timestamptz DEFAULT now()
);
3 Likes