Welcome to my scratch pad of technical things I don't feel like forgetting.
Mount options for ssd:
/dev/sda / ext4 discard,noatime,errors=remount-ro 0 1
It's been a while, but I have added yet more stuff to my growing page of psql tips and tricks. I spend a lot of quality time with PostgreSQL, so I may as well capture stuff whose syntax I want to look up. I particular, look at the stuff on copying data between databases, creating new databases with flags to specify character sets and locales (or explicit lack thereof), and fun uses of psql's --single-transaction flag. Here's the link.
New! My new firewall section shows how to set up a firewall on any computer/device that has two ethernet ports. (I used an AOpen DE2700.)
How to get your R.A.T. 7 mouse to work with X:
Make a file called /etc/X11/xorg.conf (newer versions of X won't even have this file anymore) and put this in it:
Section "InputClass"
Identifier "Mouse Remap"
MatchProduct "Saitek Cyborg R.A.T.7 Mouse"
MatchDevicePath "/dev/input/event*"
Option "ButtonMapping" "1 2 3 4 5 6 7 2 9 10 11 12 0 0 0"
EndSection
This will make one of the mouse buttons, which never sends a release event to X, play nice by being reassigned/ignored.
The PostgreSQL section now lists three handy built-in functions for getting database object sizes.
The new log4j section explains how to get different threads to log to different log files.
There is not the best documentation out there on how to get a java process to listen to jconsole connection requests from other hosts. Check out my java section for notes on that.
Also: how to get server error messages from PostgreSQL JDBC driver: see the PostgreSQL JDBC section for more details.
If you are looking for my open-source Python take on iBATIS called Pybatis (now MyBATIS), Look here.
Things C.J. Date recommends.
Ubuntu Firewall setup explains how to set up a firewall on Ubuntu 8.04 server edition.
How to make your crappy PC keyboard act like a Unix keyboard, including an updated keydump for Fedora 10 (as well as the older goodness for F9 and lower).
updated notes on getting key-based ssh authentication working, especially with a fix on home directory permissions for Fedora!
updated version of PostgreSQL syntax highlighting file for vim.
A brief guide on starting a new project using Git, including notes on bare remote repositories, which are not super-obvious from the Git documentation.