postgres-rag

Introduction

This project builds the PostgreSQL 18 image with additional extensions compiled from source.

PostgreSQL and its extensions

The image is based on postgres:18-trixie and includes:

• pgvector (0.8.1) for vector similarity search.
• Apache AGE (1.7.0) for graph capabilities.

How to use

Run

docker run --name dyingbleed/postgres-rag -p 5432:5432 -e POSTGRES_USER=postgresUser -e POSTGRES_PASSWORD=postgresPW -e POSTGRES_DB=postgresDB -d postgres-rag:latest
docker exec -it dyingbleed/postgres-rag psql -d postgresDB -U postgresUser

Enable extensions in a database

CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION IF NOT EXISTS age;