Haoyang advpetc

backup instructions

Here are some scripts which will backup all databases in a cluster individually, optionally only backing up the schema for a set list. The reason one might wish to use this over pg_dumpall is that you may only wish to restore individual databases from a backup, whereas pg_dumpall dumps a plain SQL copy into a single file. This also provides the option of specifying which databases you only want the schema of. The idea is to run these in a nightly cron job.

pg_backup.config

The main configuration file. This should be the only file which needs user modifications.

pg_backup.sh

The normal backup script which will go through each database and save a gzipped and/or a custom format copy of the backup into a date-based directory.

pg_backup_rotated.sh

The same as above except it will delete expired backups based on the configuration.

	// x^n (n can be negative)
	double myPow(double x, int n) {
	typedef long long LL;
	bool is_minus = n < 0;
	double res = 1;
	for (LL k = abs(LL(n)); k; k >>= 1) {
	if (k & 1) res *= x;
	x *= x;
	}
	if (is_minus) res = 1 / res;

	/* Binary search */

	// find first element from the sorted list that is greater than certain number

	// e.g. find 3 from [2, 4, 5, 6, 9], ans should be the index of element 4 (first greater than)
	int find(vector<int>& nums, int target) {
	int left = 0, right = nums.size();
	while (left < right) {
	int mid = left + (right - left) / 2;
	if (nums[mid] < target) left = mid + 1;

	import redis

	class Monitor():
	def __init__(self, connection_pool):
	self.connection_pool = connection_pool
	self.connection = None

	def __del__(self):
	try:
	self.reset()

	from nltk.tokenize.util import is_cjk

	nltk_punc_range = (65280, 65519)

	def eli_cjk(text):
	"""
	>>> eli_cjk("yes（中文），好玩".decode('utf8'))
	u'yes'
	>>> eli_cjk("how are you".decode('utf8'))
	u'how are you'

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console