gistfile1.rb

#!/opt/ruby-enterprise/bin/ruby


FILES = '/home/rankers/production.rankers.co.nz/shared/system'
DATABASE = 'rankers_production'


# End configuration


$start_time = Time.now

def elapsed_time
  ""
end


puts elapsed_time+"Begin"


# PostgreSQL dump
dump_bucket = "rankers-pgsql-"+Time.now.year.to_s
dump_filename = "pgdump-#{DATABASE}-"+Time.now.strftime('%Y-%m-%d-%H-%M-%S')+".bz2"
dump_path = "/tmp/#{dump_filename}"

`/opt/ruby-enterprise/bin/s3cmd createbucket #{dump_bucket}`
puts elapsed_time+"Created bucket #{dump_bucket}"

`pg_dump --format=t --blobs --clean --create --encoding=UTF-8 --no-owner #{DATABASE} | bzip2 > #{dump_path}`
puts elapsed_time+"Dumped #{DATABASE} to #{dump_path}"

`/opt/ruby-enterprise/bin/s3cmd put #{dump_bucket}:#{dump_filename} #{dump_path}`
puts elapsed_time+"Uploaded #{DATABASE} to #{dump_bucket}"

`rm #{dump_path}`


# Files
files_bucket = "rankers-files"

`/opt/ruby-enterprise/bin/s3cmd createbucket #{files_bucket}`
puts elapsed_time+"Created bucket #{files_bucket}"

`/opt/ruby-enterprise/bin/s3sync -r -v #{FILES} #{files_bucket}:`
puts elapsed_time+"Synced #{FILES} to #{files_bucket}"