David davidchua

## gist:8e3e85726d852fef86db41dad1cc70fb
UPDATE pg_index
SET indisready=false
WHERE indrelid = (
    SELECT oid
    FROM pg_class
    WHERE relname='<TABLE_NAME>'
);

UPDATE pg_index
SET indisready=true

## nginx.grok
%{IPORHOST:client_ip} - \[%{IPORHOST:x_forwarded_for}\] - %{DATA:client_identity} \[%{HTTPDATE:timestamp}\] \"(?:%{WORD:verb} %{NOTSPACE:request}(?: HTTP/%{NUMBER:httpversion})?|-)\" %{NUMBER:response} (?:%{NUMBER:bytes_sent;long}|-) (?:"(?:%{URI:referrer}|-)") %{QS:user_agent} %{NUMBER:request_length;long} %{NUMBER:response_time;double} %{DATA:upstream_proxy} %{NUMBER:upstream_bytes_sent;long} %{NUMBER:upstream_response_time} %{NUMBER:upstream_response}

## redis-server-for-init.d-startup
#! /bin/sh
### BEGIN INIT INFO
# Provides:		redis-server
# Required-Start:	$syslog
# Required-Stop:	$syslog
# Should-Start:		$local_fs
# Should-Stop:		$local_fs
# Default-Start:	2 3 4 5
# Default-Stop:		0 1 6
# Short-Description:	redis-server - Persistent key-value db

## zerigo_to_aws_route53.rb
#!/usr/local/rvm/rubies/ruby-1.9.2-p180/bin/ruby

require 'rubygems'
require 'zerigo_dns'
require 'route53'

Zerigo::DNS::Base.user = 'username@email.com'
Zerigo::DNS::Base.api_key = 'yourkeyhere'

# iterate through all domain names
	UPDATE pg_index
	SET indisready=false
	WHERE indrelid = (
	SELECT oid
	FROM pg_class
	WHERE relname='<TABLE_NAME>'
	);

	UPDATE pg_index
	SET indisready=true
	#! /bin/sh
	### BEGIN INIT INFO
	# Provides: redis-server
	# Required-Start: $syslog
	# Required-Stop: $syslog
	# Should-Start: $local_fs
	# Should-Stop: $local_fs
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: redis-server - Persistent key-value db
	#!/usr/local/rvm/rubies/ruby-1.9.2-p180/bin/ruby

	require 'rubygems'
	require 'zerigo_dns'
	require 'route53'

	Zerigo::DNS::Base.user = 'username@email.com'
	Zerigo::DNS::Base.api_key = 'yourkeyhere'

	# iterate through all domain names