scripts/backup/postgres_backup_v2.sh


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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