シェルスクリプト
-----------------------------------------------
#!/bin/sh
bak=`date +%y%m%d`
mkdir -m 700 /home/postgres/backup/$bak
cp /home/postgres/backup/file.txt /home/postgres/backup/$bak/inquiry_db_backup.$bak
/var/local/pgsql/bin/pg_dump inquiry > /home/postgres/backup/$bak/inquiry_db_backup.$bak
chmod 400 /home/postgres/backup/$bak/inquiry_db_backup.$bak
-----------------------------------------------
Point!
pg_dump は絶対パスで書くこと！
cron
http://park15.wakwak.com/~unixlife/linux/sys-cron.html
http://d.hatena.ne.jp/NekoDaisuki/20061117
set cron
1. login postgres
2. crontab -e
3. open vi
4. 0 4 * * * /home/postgres/backup/bak.sh
cron 実行コマンド作成ツール
http://www.japan9.com/cgi/cron.cgi