vehicle_rent_management/db/README.md

Database backup

mv_rent_backup.sql is a plain-SQL PostgreSQL dump of the mv_rent database (schema + data), created with:

pg_dump --no-owner --no-privileges --clean --if-exists mv_rent -f db/mv_rent_backup.sql

It includes DROP ... IF EXISTS before each object, so restoring overwrites the target database's contents.

⚠️ Contains application data: user emails and bcrypt-hashed passwords (not plaintext). Keep this repository private.

Restore

Into a local Postgres:

createdb mv_rent 2>/dev/null   # if it doesn't exist yet
psql -h localhost -U postgres -d mv_rent -f db/mv_rent_backup.sql

Into the Docker Compose deployment (server or local):

cd /opt/mvrent        # or your project dir
docker compose exec -T db psql -U postgres -d mv_rent < db/mv_rent_backup.sql

Stop the app container first if you want a clean restore without it writing concurrently: docker compose stop app && …restore… && docker compose start app.