danilchenko

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

danilchenko

#!/bin/bash
# mysql backup
mysqldump --user={USERNAME} --host=localhost --password={PASSWORD} {DATABASE_NAME} > /backups/{SITE}/{DATABASE_NAME}.sql;
tar -Jcf /backups/{SITE}/DB-`date +%F--%H-%M`.tar.gz /backups/{SITE}/{DATABASE_NAME}.sql;
rm /backups/{SITE}/{DATABASE_NAME}.sql -rf;
# files backup
tar -Jcf /backups/{SITE}/FILES-`date +%F--%H-%M`.tar.gz /var/www/{SITE}/*;
find /backups/{SITE} -type f -mtime +5 -delete; # delete files older than 5 days