From 69a416caa2bce3dc4a3aff61fb8ae955f7561e51 Mon Sep 17 00:00:00 2001 From: ivarlovlie Date: Tue, 1 Feb 2022 19:25:41 +0100 Subject: Reorganise scripts --- scripts/backup/postgres_backup_v1.sh | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100755 scripts/backup/postgres_backup_v1.sh (limited to 'scripts/backup/postgres_backup_v1.sh') 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 -- cgit v1.3