Backup and restore

Bare Metal

Backup

PGPASSWORD="YOUR_PASSWORD" pg_dump -U mbin mbin > dump.sql

Restore

psql -U mbin mbin < dump.sql

Docker

Backup:

docker compose exec -it postgres pg_dump -U mbin mbin > dump.sql

Restore:

docker compose exec -T postgres psql -U mbin mbin < dump.sql