Backup de banco de dados

[FerroEduardo]

Fazer backup do banco de dados e armazenar por um tempo determinado (1 sem/30 dias/etc)

[FerroEduardo]

#!/bin/bash

DIRECTORY=/home/my-username/dumps/
TODAY="$(date "+%Y.%m.%d-%H.%M.%S")"
USER=database-user
DATABASE=database
SCHEMA=schema

pg_dump --inserts -w -U $USER -d $DATABASE --file="$DIRECTORY/$SCHEMA-$TODAY.sql" --schema=$SCHEMA

KEEP_N_LATEST_FILES=5
ls -tp | grep -E -i "^$SCHEMA*.*\.sql$" | grep -v '/$' | tail -n +$KEEP_N_LATEST_FILES | xargs -d '\n' -r rm --