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.
PostgreSQL
Using pgAdmin running in Docker to access a dockerized PostgreSQL
In this article we’ll show how to set-up pgAdmin running with Docker to access a PostgreSQL database also running as a Docker container on the same host.
Using SQL Developer with PostgreSQL
Quick guide on how to connect to a PostgreSQL database using Oracle SQL Developer.
COPY data between localhost and PostgreSQL running with Docker
A short article showing how to easily use the COPY command to move data between localhost and a PostgreSQL database running with Docker.
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.