Pete Hawkins phawk

## upgrade-postgres-9.3-to-9.4.md

      
              1 file
            
          
              21 forks
            
          
              21 comments
            
          
              110 stars
            
          
                dideler
                / upgrade-postgres-9.3-to-9.4.md
            
            
              Last active
              June 8, 2020 03:24
            
              
                Upgrading PostgreSQL from 9.3 to 9.4 when upgrading Ubuntu 14.04 to 14.10
              
          
    TL;DR
Create a backup:
pg_dumpall > mybackup.sql
Perform the upgrade:
sudo pg_dropcluster 9.4 main --stop

  
## gist:1095522
heroku addons:add pgbackups --remote staging
heroku addons:add pgbackups --remote production
heroku pgbackups:capture --remote production
heroku pgbackups:restore DATABASE `heroku pgbackups:url --remote production` --remote staging

## birthday_liker.rb
require 'date'
require 'koala'

class BirthdayLiker
  FACEBOOK_TOKEN   = 'your_oauth_key'
  BIRTHDAY_WORDS   = %w(birthday bday birfday birth born)
  THANKS_OPTIONS   = ['Thank you!', 'Thanks!', 'Appreciate it!']
  DATE_TIME_FORMAT = '%Y-%m-%d'

  def initialize(birthdate, opts={})

## switch_audio.applescript
on alfred_script(q)
    set output_devices to {"Display Audio", "Generic USB Audio Device   "}
    set input_devices to {"Display Audio", "Generic USB Audio Device   "}
    set device_keywords to {"speakers", "headphones"}

    tell application "System Preferences"
        reveal anchor "output" of pane id "com.apple.preference.sound"

        tell application "System Events"
            tell process "System Preferences"

## webserver_with_proxied_api.rb
#!/usr/bin/env ruby

# serve the contents under www/ with a web server via port 8080 and proxy all
# requests to /api/* to an external API

# Steven Wilkin | @stevebiscuit

require 'net/http'
require 'webrick'
require 'uri'
	heroku addons:add pgbackups --remote staging
	heroku addons:add pgbackups --remote production
	heroku pgbackups:capture --remote production
	heroku pgbackups:restore DATABASE `heroku pgbackups:url --remote production` --remote staging
	require 'date'
	require 'koala'

	class BirthdayLiker
	FACEBOOK_TOKEN = 'your_oauth_key'
	BIRTHDAY_WORDS = %w(birthday bday birfday birth born)
	THANKS_OPTIONS = ['Thank you!', 'Thanks!', 'Appreciate it!']
	DATE_TIME_FORMAT = '%Y-%m-%d'

	def initialize(birthdate, opts={})
	on alfred_script(q)
	set output_devices to {"Display Audio", "Generic USB Audio Device "}
	set input_devices to {"Display Audio", "Generic USB Audio Device "}
	set device_keywords to {"speakers", "headphones"}

	tell application "System Preferences"
	reveal anchor "output" of pane id "com.apple.preference.sound"

	tell application "System Events"
	tell process "System Preferences"
	#!/usr/bin/env ruby

	# serve the contents under www/ with a web server via port 8080 and proxy all
	# requests to /api/* to an external API

	# Steven Wilkin \| @stevebiscuit

	require 'net/http'
	require 'webrick'
	require 'uri'