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`"

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐