Script de backup feito na aula de PostgreSQL Adm - TT

backup_fisico.sh

#!/bin/bash

export PGUSER='postgres'
dia_backup=$(date -I)
data_dir=$(psql -c "show data_directory" -At)
archive_dir='/dados/archive_log'
backup_dir='/dados/backup'

psql -U postgres -c "SELECT pg_start_backup('backup_"${dia_backup}"');"

echo criando diretorio temporario
temp_dir="${backup_dir}/temp"
mkdir -p ${temp_dir}
cd ${temp_dir}

echo copiando pgdata
tar czf pgdata_${dia_backup}.tar.gz ${data_dir}

psql -U postgres -c "SELECT pg_stop_backup();"

echo copiando wals arquivados
temp_wal_dir="${temp_dir}/wals_${dia_backup}"
mkdir -p ${temp_wal_dir}
cp ${archive_dir}/* ${temp_wal_dir}

echo compactar tudo
tar cf ${backup_dir}/backup_${dia_backup}.tar *

echo removendo temporario
cd -
rm -rf ${temp_dir}