Send Postgresql Logs to Another Server
#!/bin/bash
##########################################################################
# PostgreSQL Send Logs One day Before Using SCP(USE SSH AUTHENTICATION)=Broke Keygen(rsa&dsa)
#Author:DineshKumar Asokan
###################################################################
DATE=$(date +%G-%m-%d--%H-%M-%S)
CHECK_LOG=/home/enterprisedb/$PGDATABASE_$DATE.log
echo "Starting Scp ######$DATE######" >>CHECK_LOG
for a in ` find /pg_tdbdata/pg_data9.3As/pg_log/*.log -mtime +1 -name '*.log' `
do
scp -r $a enterprisedb@10.236.243.151:/bkp/logs/tdb/
done
echo "End this Scp completed#####$DATE ######" >>CHECK_LOG
if [ $? -ne 0 ]
then
echo " SCP Sedning failed"
exit 1;
fi
echo "SCP Completed Successfuly ####$DATE#####" >> $CHECK_LOG
Comments
Post a Comment