From 014240bf83e5fb9cb4c3f3c25f3eedc75303377b Mon Sep 17 00:00:00 2001 From: Emilie Date: Thu, 10 Aug 2017 15:05:52 +0200 Subject: [PATCH] [db] : add new push script + update backup.sh --- db/backup.sh | 4 ++-- mezzo-push.sh | 7 +++++++ 2 files changed, 9 insertions(+), 2 deletions(-) create mode 100755 mezzo-push.sh diff --git a/db/backup.sh b/db/backup.sh index 2ffa0ba..f06c870 100755 --- a/db/backup.sh +++ b/db/backup.sh @@ -10,8 +10,8 @@ if [ ! -z "$MYSQL" ]; mysqldump $MYSQL_DATABASE -hdb -u$MYSQL_USER > /srv/backup/mariadb.dump elif [ ! -z "$POSTGRES" ]; then - export PGUSER=$POSTGRES_PASSWORD - export PGPASSWORD=$DB_ROOT_PASSWORD + export PGUSER="postgres" + export PGPASSWORD=$POSTGRES_PASSWORD export PGDATABASE="postgres" pg_dump -Fc -hdb > /srv/backup/postgres.dump fi diff --git a/mezzo-push.sh b/mezzo-push.sh new file mode 100755 index 0000000..7a5d2a3 --- /dev/null +++ b/mezzo-push.sh @@ -0,0 +1,7 @@ +echo "----------------------------" +echo `date +\%Y\%m\%d-\%H-\%M-\%S` +docker-compose run db /srv/bin/db/backup.sh +git add var +git commit -a -m "update DB and media" +git pull +git push -- 2.39.5