shell 脚本并行连接 postgresql 数据库执行脚本
·
PGTARGET=(
'aws-test-pg1.cluster-xxxxx.ap-northeast-1.rds.amazonaws.com 5432 dbaadmin db1 /tmp/pg1.sql'
'aws-test-pg2.cluster-xxxxx.ap-northeast-1.rds.amazonaws.com 5432 dbaadmin db2 /tmp/pg2.sql'
'aws-test-pg3.cluster-xxxxx.ap-northeast-1.rds.amazonaws.com 5432 dbaadmin db3 /tmp/pg3.sql'
'aws-test-pg4.cluster-xxxxx.ap-northeast-1.rds.amazonaws.com 5432 dbaadmin db4 /tmp/pg4.sql'
)
PGPASS=$1
LOGFILE=/tmp/pg_delete_data.log
echo "start......`date`"
for DATABASE in "${PGTARGET[@]}";
do
echo "${DATABASE}"
DATABASEROW=($DATABASE)
#echo "PGPASSWORD=${PGPASS} "
(PGPASSWORD=${PGPASS} /usr/bin/psql -h ${DATABASEROW[0]} -p ${DATABASEROW[1]} -U ${DATABASEROW[2]} ${DATABASEROW[3]} -f ${DATABASEROW[4]} )&
done
wait
echo "end......`date`"
更多推荐
所有评论(0)