- #!/bin/sh
- export PGPASSWORD='Finance@unicom23'
- backup_dir=$1
- host='172.16.107.5'
- port='5432'
- username='finance'
- dbname='financialdb'
- jobs='16'
- if [ "$(psql -U ${username} -tAc "SELECT 1 FROM pg_database WHERE datname='${dbname}'")" != "1" ]; then
- createdb -U ${username} ${dbname}
- fi
- pg_restore -O -c -v -h "${host}" -p "${port}" -U "${username}" -d "${dbname}" -Fd -j "${jobs}" "${backup_dir}"
|
