Easy end-to-end guide for getting PostgreSQL with the pgvector extension up & running with Docker and using it as a vector store in n8n. Including sample workflows for storing extracted data from a PDF as OpenAI embeddings and querying it with a simple RAG agent.
Postgres
Running PostgreSQL with Docker on Linux using local persistent data storage
A quick guide demonstrating how to get PostgreSQL up & running in minutes under Linux using Docker. We’ll create local persistent data storage using a Docker volume and connect from localhost with psql.