Alvin Lai alvinlai

A quick "how to" on what you need to do to both setup AND recover a single-server PostgreSQL database using WAL-E

WAL-E: https://github.com/wal-e/wal-e
Assuming Ubuntu 12.04 LTS ("Precise")
We'll be using S3. Make sure you have an IAM in a group with GetObject, ListBucket and PutObject on the bucket you want to use (and that it's not public).

Setup:

These packages:

Keybase proof

I hereby claim:

I am alvinlai on github.
I am alvin (https://keybase.io/alvin) on keybase.
I have a public key whose fingerprint is 6591 436D 1204 D8F6 3637 0B86 5B31 C344 3D9A B050

To claim this, I am signing this object:

Basecamp was under network attack

The attack detailed below has stopped (for the time being) and almost all network access for almost all customers have been restored. We're keeping this post and the timeline intact for posterity. Unless the attack resumes, we'll post a complete postmortem within 48 hours (so before Wednesday, March 26 at 11:00am central time).

Criminals have laid siege to our networks using what's called a distributed denial-of-service attack (DDoS) starting at 8:46 central time, March 24 2014. The goal is to make Basecamp, and the rest of our services, unavailable by flooding the network with bogus requests, so nothing legitimate can come through. This attack was launched together with a blackmail attempt that sought to have us pay to avoid this assault.

Note that this attack targets the network link between our servers and the internet. All the data is safe and sound, but nobody is able to get to it as long as the attack is being successfully executed. This is like a bunch of people

	#!/bin/bash

	# Start/stop an EC2 instance for use as an ssh tunnel
	# requires the aws package locally -- sudo apt-get install awscli
	#
	# usage: ./tunnel.sh start (spin up EC2 and create the tunnel)
	# ./tunnel.sh stop (terminate the EC2 instance to save money)
	# ./tunnel.sh resume (in case your tunnel is interrupted but the EC2 instance is still running)

	# CHANGE THE PARAMETERS BELOW

	import cv2.cv as cv
	import tesseract
	gray = cv.LoadImage('captcha.jpeg', cv.CV_LOAD_IMAGE_GRAYSCALE)
	cv.Threshold(gray, gray, 231, 255, cv.CV_THRESH_BINARY)
	api = tesseract.TessBaseAPI()
	api.Init(".","eng",tesseract.OEM_DEFAULT)
	api.SetVariable("tessedit_char_whitelist", "0123456789abcdefghijklmnopqrstuvwxyz")
	api.SetPageSegMode(tesseract.PSM_SINGLE_WORD)
	tesseract.SetCvImage(gray,api)
	print api.GetUTF8Text()

	module ReadMarkable
	extend ActiveSupport::Concern

	included do

	has_many :read_marks

	def touch_read_at
	update_column(:read_at, Time.now)
	end

	((d, s, id) ->
	js = undefined
	fjs = d.getElementsByTagName(s)[0]
	return if d.getElementById(id)
	js = d.createElement(s)
	js.id = id
	js.src = "//connect.facebook.net/en_US/all.js#xfbml=1"
	fjs.parentNode.insertBefore js, fjs
	) document, "script", "facebook-jssdk"

	function dfwd {
	VBoxManage modifyvm "boot2docker-vm" --natpf1 "tcp-port$1,tcp,127.0.0.1,$1,,$1"
	}

	function ddfwd {
	VBoxManage modifyvm "boot2docker-vm" --natpf1 delete "tcp-port$1"
	}