Skip to content

PostgreSQL

Overview

  • Powerful, open-source database system. Free to use, modify, and distribute.
  • Object-relational database (ORDBMS), it combines features of relational databases with object-oriented principles, allowing for more complex data structures.
  • Highly regarded for its reliability, data integrity, and ACID compliance.
  • Supports complex queries, advanced data types (like JSON and arrays), and full-text search.
  • Highly extensible, allowing users to define their own data types, functions, and operators.
  • Handles high-concurrency workloads well, managing many simultaneous users and transactions efficiently.
  • Strong, active community that has been developing and improving it for over 30 years.

Up and Running

podman run -d \
  --name postgres \
  --network llm-stack \
  -e POSTGRES_PASSWORD=PUT_POSTGRES_PASSWORD_HERE \
  -e PGDATA=/var/lib/postgresql/data/pgdata \
  -v postgres:/var/lib/postgresql/data \
  -p 127.0.0.1:5432:5432 \
  pgvector/pgvector:pg17

podman logs -f postgres

Usage

podman exec -ti -u postgres postgres psql