Database Backup & Restore (Production → Dev)

Dumps a PostgreSQL database from a remote production server (via SSH + Docker) and restores it into a local Docker Compose PostgreSQL instance. Agnostic to the specific project — works with any Dockerized Postgres setup.

Prerequisites

• SSH access to the production server with a key file
• Production database running inside a Docker container (or Swarm service)
• Local dev environment using Docker Compose with a Postgres service

Key Paths (WitDev Ecosystem)