db_export.sh

#!/bin/bash

if [ ! -d database_dumps ]; then
  mkdir database_dumps
fi

docker exec -t pgsql pg_dumpall -c -U postgres > ./database_dumps/dump_latest.sql
cp ./database_dumps/dump_latest.sql ./database_dumps/dump_`date +%Y%m%d"_"%H%M%S`.sql

echo "### Export Complete."