写了一个备份Postgresql数据文件的超简单Linux Shell

lovejuan1314

#!/bin/bash#author:lovejuan1314#date:2008-12-19#This script will dump servers's views data per month###Define a array to store all of table names which will be backuped to herearray=(`psql --quiet --tuples-only  -h server_name -p 5432 -U slony db_name -c "SELECT tablename  FROM pg_tables WHERE tablename like 'fb_fy_views_%';"`)#Array 's length  len=${#array[ * ]} echo "The array has $len members. They are:"i=0while [ $i -lt $len ]; do        echo "$i: ${array[$i]}"        #dump  table        pg_dump -t ${array[$i]}  -i -O  -h server_name -p 5432 -U slony -f "${array[$i]}.pgdump" -F c -Z 9 db_name        let i++donetar czvf .tar.gz *.pgdumprm -rf *.pgdump