postgres.conf

# Custom PostgreSQL configuration for MedCover dev/prod.
#
# Key goal: reduce the dirty-page window so that an unclean shutdown
# (e.g. WSL2 force-kill, OOM) loses at most ~30 s of committed writes
# instead of the default 5 minutes.

# --- Checkpointing ---
# Write dirty pages to disk every 30 s (default: 5min).
checkpoint_timeout = 30s

# Spread checkpoint I/O over 90 % of the interval to avoid I/O spikes.
checkpoint_completion_target = 0.9

# --- WAL / durability (keep defaults — do NOT disable fsync) ---
fsync = on
synchronous_commit = on

# --- Network ---
# Must be set explicitly when overriding the full config file; otherwise
# PostgreSQL defaults to localhost-only and other containers can't connect.
listen_addresses = '*'

# --- Logging (helpful for diagnosing crashes) ---
log_checkpoints = on
log_connections = off
log_disconnections = off