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}"