Skip to content

Instantly share code, notes, and snippets.

View davidchua's full-sized avatar

David davidchua

98 followers · 60 following
View GitHub Profile
@davidchua
davidchua / gist:8e3e85726d852fef86db41dad1cc70fb
Created December 24, 2021 14:42 — forked from cirode/gist:9666edb6ef20d0bd1e891b4bcdc26b7a
Disable indexes postgres
UPDATE pg_index
SET indisready=false
WHERE indrelid = (
SELECT oid
FROM pg_class
WHERE relname='<TABLE_NAME>'
);
UPDATE pg_index
SET indisready=true
@davidchua
davidchua / nginx.grok
Created January 31, 2019 07:10 — forked from msiegenthaler/nginx.grok
Grok pattern for nginx ingress in Kubernetes
%{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}
@davidchua
davidchua / redis-server-for-init.d-startup
Last active December 20, 2015 03:19 — forked from lsbardel/redis-server-for-init.d-startup
wget -O /etc/init.d/redis-server https://gist.github.com/davidchua/6062428/raw/ chmod 755 /etc/init.d/redis-server update-rc.d redis-server defaults # run it on 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
@davidchua
davidchua / zerigo_to_aws_route53.rb
Last active February 22, 2017 20:19
quick and dirty ruby script to copy dns from zerigo to amazon aws route 53 (route53). allows users to migrate ALL zones from zerigo over to Route53
#!/usr/local/rvm/rubies/ruby-1.9.2-p180/bin/ruby
require 'rubygems'
require 'zerigo_dns'
require 'route53'
Zerigo::DNS::Base.user = '[email protected]'
Zerigo::DNS::Base.api_key = 'yourkeyhere'
# iterate through all domain names