PostgreSQL with Docker

This project runs PostgreSQL in Docker and exposes it on your machine.

1) Configure environment

cp .env.example .env

Edit .env and set a strong POSTGRES_PASSWORD.

2) Start database

docker compose up -d --build

3) Verify it is running

docker compose ps
docker compose logs -f postgres

Connection details

• Host: localhost
• Port: value of POSTGRES_PORT (default 5432)
• Database: value of POSTGRES_DB
• User: value of POSTGRES_USER
• Password: value of POSTGRES_PASSWORD

Example:

psql "postgresql://hemas_user:change_me@localhost:5432/hemas_db"