dyingbleed/postgres-rag repository overview

⁠postgres-rag

GitHub⁠

⁠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;