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

Popular Posts