Changeset 196 for trunk

Show
Ignore:
Timestamp:
11/16/10 15:32:57 (3 years ago)
Author:
denish
Message:

Making email address list as variable

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/tools/email_locked_queries.sh

    r194 r196  
    1212LOGFILE=/home/postgres/logs/email_locked_queries.rpt 
    1313DNAME=your_real_postgres_db_name 
     14EMAIL_LIST=dba@omniti.cm 
    1415 
    1516psql  -d ${DNAME} -x -t -q  -c  "  
     
    4142 
    4243if [ $FILESIZE -ge 11 ]; then 
    43         mailx -s "DB locked queries for ${DNAME} on ${M_HOSTNAME}" dba@omniti.com < $LOGFILE  
     44        mailx -s "DB locked queries for ${DNAME} on ${M_HOSTNAME}" $EMAIL_LIST < $LOGFILE  
    4445fi 
    4546