Sandro Doro sdoro

sdoro / gist:4010971

Created November 4, 2012 09:57

SSH Key Setup - HA cluster

	# we can share the SSH keys that the service uses

	node1# cd /etc/ssh/
	node1# mkdir BAK
	node1# cp -p ssh_host_* BAK
	node1# scp node2:/etc/ssh/ssh_host* .

sdoro / gist:4010872

Created November 4, 2012 09:15

bash configuration ~/.bashrc

	# History
	export HISTCONTROL=ignoredups:erasedups
	export HISTSIZE=50000
	export HISTFILESIZE=50000
	export HISTTIMEFORMAT="%F %T "

	# alias
	alias l='ls -la'
	alias df='df -h'

sdoro / gist:4009341

Created November 3, 2012 23:40

snippet corosync.conf

sdoro / gist:4009275

Created November 3, 2012 23:26

Install pacemaker/corosync from Debian backports

apt-get -t squeeze-backports install corosync pacemaker

sdoro / gist:4009258

Created November 3, 2012 23:20

Debian squeeze-backports

	cat /etc/apt/sources.list.d/backports.list
	deb http://backports.debian.org/debian-backports squeeze-backports main contrib non-free

sdoro / gist:4006838

Created November 3, 2012 09:44

Generate ssh key without passphrase

	ssh-keygen -q -b 2048 -f ~/.ssh/id_rsa -N ""
	# add -C "comment" to insert comment in *.pub file

sdoro / gist:4003626

Created November 2, 2012 18:58

PostgreSQL Auto Increment

	CREATE SEQUENCE mgr_id_seq;

	CREATE SEQUENCE;

	CREATE TABLE managers(
	mgr_id INTEGER PRIMARY KEY DEFAULT NEXTVAL('mgr_id_seq'),
	mgr_name VARCHAR(50),
	mgr_email VARCHAR(50)
	);

sdoro / gist:4002209

Created November 2, 2012 15:55

How can you calculate the number of days since 1/1/1970?

echo $((`date --utc --date "$1" +%s`/86400))