Kent Pham hungpk

Ideal Postgres environment

Documented replication topology
Documented network topology
Documented interface topology - including users, passwords, connection estimates, load balancers, connection proxies
Documented procedure, schedule for failover and testing
Documented procedure, schedule for disaster recovery and testing

WAL-E needs to be installed on all machines, masters and slaves.

Only one machine, the master, writes WAL segments via continuous archiving. The configuration for the master postgresql.conf is:

archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p'
archive_timeout = 60

Install ImageMagick for image conversion:

brew install imagemagick

Install tesseract for OCR:

brew install tesseract --all-languages

Or install without --all-languages and install them manually as needed.

WAL-E needs to be installed on all machines, masters and slaves.

Only one machine, the master, writes WAL segments via continuous archiving. The configuration for the master postgresql.conf is:

archive_mode = on
archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p'
archive_timeout = 60

	#!/bin/bash

	#Force file syncronization and lock writes
	mongo admin --eval "printjson(db.fsyncLock())"

	MONGODUMP_PATH="/usr/bin/mongodump"
	MONGO_HOST="prod.example.com"
	MONGO_PORT="27017"
	MONGO_DATABASE="dbname"

	# run with: god -c /path/to/config.god [add -D if you want to not-deamonize god]
	# This is the actual config file used to keep the delayed_job running

	APPLICATION_ROOT = "/var/www/application"
	RAILS_ENV = "production"

	God.watch do \|w\|
	w.name = "delayed_job_production"
	w.interval = 15.seconds
	w.start = "/bin/bash -c 'cd #{APPLICATION_ROOT}/current; /usr/bin/env RAILS_ENV=#{RAILS_ENV} #{APPLICATION_ROOT}/current/script/delayed_job start > /tmp/delay_job.out'"

	load 'deploy/assets'

	namespace :deploy do
	namespace :assets do
	desc 'Run the precompile task locally and rsync with shared'
	task :precompile, :roles => :web, :except => { :no_release => true } do
	%x{bundle exec rake assets:precompile}
	%x{rsync --recursive --times --rsh=ssh --compress --human-readable --progress public/assets #{user}@#{host}:#{shared_path}}
	%x{bundle exec rake assets:clean}
	end

	curl https://raw.github.com/git/git/master/contrib/completion/git-completion.bash -o ~/.git-completion.bash
	echo "source ~/.git-completion.bash" >> ~/.bash_profile