Postgres

Upsert embedded data and perform similarity search upon query using pgvector on Postgres.

Postgres Node

There are multiple methods to connect to Postgres based on how your instance is set up. Below is an example of a local configuration using a prebuilt Docker image provided by the pgvector team.

Create a file named docker-compose.yml with the content below:

# Run this command to start the database:
# docker-compose up --build
version: "3"
services:
  db:
    hostname: 127.0.0.1
    image: pgvector/pgvector:pg16
    ports:
      - 5432:5432
    restart: always
    environment:
      - POSTGRES_DB=api
      - POSTGRES_USER=myuser
      - POSTGRES_PASSWORD=ChangeMe
    volumes:
      - ./init.sql:/docker-entrypoint-initdb.d/init.sql

docker compose up to start the Postgres container.

Create new credential with the configured user and password:

Fill in the node's field with values configured in docker-compose.yml. For example:

• Host: localhost

• Database: api

• Port: 5432

Voila! You have now successfully setup Postgres Vector ready to be used.