In this post i'll liste my useage of docker.

Docker postgres

In a project i work with

Sauvegarde une base de donnee

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_date +%d-%m-%Y"_"%H_%M_%S.sql

Update a postgres database with a script

docker cp update_script.sql Idcontainer:/home/update_script.sql
docker exec -it Idcontainer psql -U user database -a -f /home/update_script.sql