Skip to content

Latest commit

 

History

History
37 lines (25 loc) · 1.06 KB

README.md

File metadata and controls

37 lines (25 loc) · 1.06 KB

do-parking-stats-collector

Collects live statistics about occupied parking lots in Dortmund's parking garages from the official Open Data API. Parking statistics are stored in a postgres database.

Installation

  1. Create an .env file with variables used by postgres and collector containers:

    POSTGRES_USER=<name>
POSTGRES_PASSWORD=<password>

CONNECTION_URL=postgres://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres:5432
DATABASE_NAME=do_parking
DATABASE_URL=${CONNECTION_URL}/${DATABASE_NAME}

  2. Create and start the docker containers. Required databases and tables are created automatically.

    docker compose up -d

Bonus: Backups

  • Create backup

    docker exec -t do-parking-stats-db-1 pg_dumpall -c -U db_user > dump_`date +%Y-%m-%d"_"%H_%M_%S`.sql

  • Restore from backup (drops and replaces all data!)

    cat dump_<date>.sql | docker exec -i do-parking-stats-db-1 psql -U db_user