Auto Backup PostgreSQL DataBase
# vi /usr/localpgsql/bin/pg_bakjedi.sh#!/bin/sh
nowtime=`/bin/date +%Y%m%d%H`
#echo $nowtime
/usr/local/pgsql/bin/pg_dump-U postgres-CD jedidb > /usr/local/pgsql/bak/jedidb$nowtime.bak
#chmod a+x /usr/localpgsql/bin/pg_bakjedi.sh
# export EDITOR=vi
# crontab -e
10 01 * * * /usr/local/pgsql/bin/pg_bakjedi.sh
页:
[1]