Linux/shell script

쉘 스크립트 Postgresql 백업

juu_98 2023. 8. 8. 16:50

#!/bin/bash
DEL_FILE=$(date -d '30 day ago' +'%Y-%m-%d_')"*.sql"
FILENAME=$(date +"%Y-%m-%d").sql
BACKUP_DIR=/backup
pg_dumpall=/usr/pgsql-14/bin/pg_dumpall

cd $BACKUP_DIR

PGPASSWORD="asdf12!@" $pg_dumpall -U test -p 15325 > "${BACKUP_DIR}/alldump_${FILENAME}"

rm "${BACKUP_DIR}/alldump_${DEL_FILE}"