usfull scripts

Auto shout down (network)
30 20 * * * /mysystem/myadmin/autoshutdown.sh

rm -rf /mysystem/myadmin/ip_shutdown_list.txt
rm -rf /mysystem/myadmin/ip_shutdown_list2.txt

cat /mysystem/myadmin/exclude_ubuntu_ip_list.txt | grep  -E -o "([0-9]{1,3}[\.]){3}[0-9]{1,3}" >> /mysystem/myadmin/ip_shutdown_list.txt
cat /mysystem/myadmin/ip_shutdown_list.txt | awk '{print "ssh root@"$0" shutdown -h now"}'  >> /mysystem/myadmin/ip_shutdown_list2.txt
cp -p /mysystem/myadmin/Full_ubuntu_IP_List.txt /mysystem/myadmin/exclude_ubuntu_ip_list.txt

bash /mysystem/myadmin/ip_shutdown_list2.txt
mail -s "Ubuntu PC Shutdown process complted "  admin@mysys.com, my2@mysys.com

schema
#!/bin/bash
cd /home/uploads/schema_backup/monthly_dm_process/dm_upload

#server1-PGRS2
echo "---------------------------------------------" >> monthly_dm_process.log
echo server1-PGRS2 monthly DM process started at $(date)  >> monthly_dm_process.log
ssh myuser@192.168.1.12 "rm -rf /home/uploads/schema_backup/monthly_dm_process/dm_backup/*"
ssh myuser@192.168.1.12 "rm -rf /home/uploads/schema_backup/monthly_dm_process/dm_upload/*"
scp dm.sql.gz myuser@192.168.1.12:/home/uploads/schema_backup/monthly_dm_process/dm_upload
echo "server1-PGRS2"
ssh myuser@192.168.1.12 "gunzip /home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.sql.gz"
ssh myuser@192.168.1.12 "/usr/local/pgsql/bin/pg_dump --file=/home/uploads/schema_backup/monthly_dm_process/dm_backup/dm.sql --username=postgres --schema=dm PGRS2"
ssh myuser@192.168.1.12 "/usr/local/pgsql/bin/psql -U postgres --file=/mysystem/myadmin/dm_schema_drop.sql PGRS2"
ssh myuser@192.168.1.12 "/usr/local/pgsql/bin/psql -U postgres --pset pager -f /home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.sql PGRS2 >>/home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.log"
echo server1-PGRS2 monthly DM process end at $(date)  >> monthly_dm_process.log

#server2-PGRS2 EIF
echo "---------------------------------------------" >> monthly_dm_process.log
echo server2-PGRS2 monthly DM process started at $(date)  >> monthly_dm_process.log
ssh myuser@192.168.1.13 "rm -rf /home/uploads/schema_backup/monthly_dm_process/dm_backup/*"
ssh myuser@192.168.1.13 "rm -rf /home/uploads/schema_backup/monthly_dm_process/dm_upload/*"
scp dm.sql.gz myuser@192.168.1.13:/home/uploads/schema_backup/monthly_dm_process/dm_upload
echo "server2-PGRS2 EIF STG DB"
ssh myuser@192.168.1.13 "gunzip /home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.sql.gz"
ssh myuser@192.168.1.13 "/usr/local/pgsql/bin/pg_dump --file=/home/uploads/schema_backup/monthly_dm_process/dm_backup/dm.sql --username=postgres --schema=dm PGRS2"
ssh myuser@192.168.1.13 "/usr/local/pgsql/bin/psql -U postgres --file=/mysystem/myadmin/dm_schema_drop.sql PGRS2"
ssh myuser@192.168.1.13 "/usr/local/pgsql/bin/psql -U postgres --pset pager -f /home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.sql PGRS2 >>/home/uploads/schema_backup/monthly_dm_process/dm_upload/dm.log"
echo server2-PGRS2 monthly DM process end at $(date)  >> monthly_dm_process.log

echo "---------------------------------------------" >> monthly_dm_process.log
echo "----ENDED SERVERS DM SCHEMA TRANSFER-----" >> monthly_dm_process.log
echo "---------------------------------------------" >> monthly_dm_process.log

echo "Dear guys,
Please run the schema verification for the following servers.

" >> monthly_dm_process.log
echo "" | mail -s "Automated monthly Staging DM process is completed successfully in the following servers" sup@my.com,dm@my.com < monthly_dm_process.log
-----------------------------------------------------------------------------------------
Auto full vacuume

#!/bin/bash

NOWDATE=$(date +"%m-%d-%Y_%H:%M")
> /mysystem/myadmin/vaccum_full.log
echo ----------- Full Vaccum started at $NOWDATE ----------- >>/mysystem/myadmin/vaccum_full.log
/usr/local/pgsql/bin/psql -U postgres -p 5432 -f /mysystem/myadmin/vaccum.sql PGRS1
NOWDATE=$(date +"%m-%d-%Y_%H:%M")
echo ----------- Full Vaccum end at $NOWDATE ----------->>/mysystem/myadmin/vaccum_full.log | mail -s "This is the status of database full vacuum in db server" a1@b.com,a2@b.com
//////in vaccum.sql-> VACUUME FULL ;////


--------------------
Cronjobs

http://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/
------------------------------------------------------------------------