Postgre backup script, trigger from another server

backup_database.rb

#!/usr/bin/env ruby

require 'dotenv'

Dir.chdir '/home/deployer/apps/APP'
Dotenv.load

DB_HOST = 'user@host'
DB_NAME = ENV['DB_NAME']

backup = "tmp/#{DB_NAME}-#{`date +'%Y-%m-%d_%H'`.chomp}.sql"

puts backup

system "sh '#{DB_HOST}' 'pg_dump --dbname=postgresql://#{DB_USER}:#{DB_PASS}@localhost:5432/#{DB_NAME} > #{DB_NAME}.sql'"
system "scp #{DB_HOST}:~/#{DB_NAME}.sql '#{backup}'"
system "gzip -f #{backup}"

backup_size = (File.size("#{backup}.gz").to_f / 2**20).round(2)
puts "Backup size in MB: #{backup_size}"

# system "aws s3 cp #{backup}"
system "aws s3 cp #{backup}.gz db-backups/#{Time.now.year}/#{Time.now.strftime("%m")}"

alternative simple

require 'colorize'

def run what
   puts what.yellow
   system what
end

###

name = ARGV[0]
day  = `date +%A`.chomp

run "rm #{name}.sql.gz"
run "pg_dump #{name} > #{name}.sql"
run "gzip #{name}.sql"
run "aws s3 cp ./#{name}.sql.gz s3://backup/#{name}-#{day}.sql.gz"