pg单库备份脚本

[root@VM_200_185_centos sh]# cat auto_pqsqlbakcup.sh
#!/bin/bash
##by 2022/07/10

host_ip=`hostname -I`
username=kong
database=kong
port=5432
pg_dump=/usr/bin/pg_dump
PSQL_BACKUP=/data/pgdata
thedate=$(date '+%Y%m%d_%H%M%S')

#check up backup root directory if exist !
if [ ! -d "$PGSQL_BACKUP" ];then
mkdir -p $PSQL_BACKUP
fi
$pg_dump -h $host_ip -U $username -p $port  -w -d $database > ${PSQL_BACKUP}/${database}backup_$thedate.sql