#!/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