PostgreSQL Database

Advanced relational database with PostgreSQL 17 Alpine. Perfect for modern applications needing robust features.

Default Configuration

Image: postgres:17-alpine
Container: damp-postgresql
Port: 5432:5432
Network: devnet
Volume: damp-pgsql:/var/lib/postgresql/data

# Using container name
psql -h damp-postgresql -U postgres -d development

Laravel .env:

DB_CONNECTION=pgsql
DB_HOST=damp-postgresql
DB_PORT=5432
DB_DATABASE=development
DB_USERNAME=postgres
DB_PASSWORD=postgres

# Using localhost
psql -h localhost -p 5432 -U postgres -d development

Connection String:

postgresql://postgres:postgres@localhost:5432/development

psql -h damp-postgresql -U postgres

CREATE DATABASE my_app;

psql -h localhost -U postgres development < dump.sql

pg_dump -h localhost -U postgres development > backup.sql

Data Persists

All databases stored in damp-pgsql volume - safe across container restarts!

JSON Support

PostgreSQL offers excellent JSON/JSONB support for semi-structured data without switching to NoSQL!