Reorganise scripts

3 files changed, 58 insertions, 0 deletions

diff --git a/scripts/backup/docker_volumes_backup.sh b/scripts/backup/docker_volumes_backup.sh
new file mode 100755
index 0000000..403c745
--- /dev/null
+++ b/scripts/backup/docker_volumes_backup.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+set -Eeuo pipefail
+
+volumes_path="/var/lib/docker/volumes"
+backup_folder="/opt/backup/docker_data"
+filename="$(date -u +%Y%m%dT%H%M%SZ).tar"
+
+[ ! -d $backup_folder ] && mkdir -p $backup_folder
+
+tar cvf $backup_folder/$filename $volumes_path
diff --git a/scripts/backup/postgres_backup_v1.sh b/scripts/backup/postgres_backup_v1.sh
new file mode 100755
index 0000000..10f3b30
--- /dev/null
+++ b/scripts/backup/postgres_backup_v1.sh
@@ -0,0 +1,31 @@
+#!/bin/bash
+
+set -Eeuo pipefail
+
+host="localhost"
+port="5432"
+user="postgres"
+databases=("vsh_store" "time_tracker")
+backup_name=$(date -u +%Y%m%dT%H%M%SZ)
+backup_folder=/opt/backup/db
+
+for i in "${databases[@]}"
+do
+
+	pushd $backup_folder
+
+	if [ ! -d "$i" ]; then
+		mkdir -p $i
+	fi
+
+	cd $i
+
+	echo "$(date -u +%Y-%m-%d_%H:%M:%SZ) Dumping $i into $backup_folder/$i/$backup_name.psql"
+	pg_dump -U $user -p $port -h $host -Fc --clean --if-exists $i -f $backup_name.psql
+
+	echo "$(date -u +%Y-%m-%d_%H:%M:%SZ) Dumping $i into $backup_folder/$i/$backup_name.sql"
+	pg_dump -U $user -p $port -h $host --inserts --clean --if-exists $i -f $backup_name.sql
+
+	popd
+
+done
diff --git a/scripts/backup/postgres_backup_v2.sh b/scripts/backup/postgres_backup_v2.sh
new file mode 100755
index 0000000..1f06514
--- /dev/null
+++ b/scripts/backup/postgres_backup_v2.sh
@@ -0,0 +1,16 @@
+#!/bin/bash
+
+set -Eeuo pipefail
+
+backup_folder="/opt/backup/db/$(date -u +%F)"
+postgres_host="127.0.0.1"
+postgres_port="5432"
+filename="$(date -u +%H%M%S).psqldump"
+
+[ ! -d $backup_folder ] && mkdir -p $backup_folder
+
+pushd $backup_folder
+
+pg_dumpall --host=$postgres_host --port=$postgres_port -U postgres --clean --if-exists -f $filename
+
+popd