jeabraham

-- 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%' 

jeabraham

# MacOS has on-the-fly decompression, but not on-the-fly compression.
# AFSC tool https://github.com/RJVB/afsctool.git is handy
# for applying compression, but if you're actively working
# on something, you'll be writing new files, meaning stuff won't stay.
# compressed.  Even saving a new
# version of a file from an application usually means a brand
# new (uncompressed) file. 

# Also, directories containing compressed files like jpg images
# or movies won't benefit from file system level compression.

jeabraham

set backup_location to "/Volumes/ExtraDisk/FamilyTreeMakerBackups"

backup_recent_tree("Abraham family tree 2018.ftm", backup_location)
backup_recent_tree("de Kat Family Tree_2017-05-13.ftm", backup_location)

on backup_recent_tree(tree_name, backup_location)
	try
		tell application "Family Tree Maker 2019"
			activate
		end tell