Yanhao Yang YanhaoYang

Frontend Development

Attention: the list was moved to

This page is not maintained anymore, please update your bookmarks.

1.8.7: parse(str='-4712-01-01', comp=false, sg=ITALY)
1.9.3: parse(string='-4712-01-01T00:00:00+00:00'[, comp=true[, start=ITALY]])

Note: the default values of comp are different.

Show active connections
- SELECT * FROM pg_stat_activity;
- ps aux | grep postgres | wc -l (roughly, when you cannot connect to it)
Show @max_connections@
- In psql: SHOW max_connections; (SHOW ALL;)
SQL: SELECT * FROM pg_settings WHERE name = 'max_connections';

	[diff]
	tool = diffmerge
	[difftool "diffmerge"]
	cmd = diffmerge \"$LOCAL\" \"$REMOTE\"
	[merge]
	tool = diffmerge
	[mergetool "diffmerge"]
	cmd = "diffmerge --merge --result=\"$MERGED\" \"$LOCAL\" \"$(if test -f \"$BASE\"; then echo \"$BASE\"; else echo \"$LOCAL\"; fi)\" \"$REMOTE\""
	trustExitCode = true

	// string.c in ruby-1.9.3-p125 src

	7896 rb_define_method(rb_cSymbol, "==", sym_equal, 1);
	7897 rb_define_method(rb_cSymbol, "===", sym_equal, 1);

	7395 static VALUE
	7396 sym_equal(VALUE sym1, VALUE sym2)
	7397 {
	7398 if (sym1 == sym2) return Qtrue;
	7399 return Qfalse;

	sudo /etc/init.d/postgresql stop

	# PostGIS 1.5.2 and its dependencies were installed already, so I
	# removed them
	sudo aptitude remove postgis postgresql-9.1-postgis \
	libgdal1-dev libgdal1-1.7.0 gdal-bin python-gdal \
	libspatialite2 libspatialite3 libgeos-dev libgeos-c1

	# install any missing prerequisites
	sudo aptitude install build-essential checkinstall postgresql \

	# 16 GB shared memory
	$ sysctl -w kernel.shmmax=17179869184
	# A page is almost always 4096 bytes except in unusual kernel configurations with "huge pages" (use getconf PAGE_SIZE to verify).
	$ sysctl -w kernel.shmall=4194304

	To preserve the settings between reboots, in /etc/sysctl.conf:
	kernel.shmmax=17179869184
	kernel.shmall=4194304

	--colour
	-I app

	"\e[1;5D": backward-word
	"\e[1;5C": forward-word