pgfouine is a nice logfile analyzer for PostgreSQL written in php. I’m doing a trace on a very long running ETL process and the logfile generated is ~11GB. I’m running up against a 2GB barrier in php for fopen(). If you’ve got a 64bit machine and can recompile php with -D_FILE_OFFSET_BITS=64 then you’re good to [...]

Desktop Favorites is one of my all time favourite widgets. But it stores it’s links as .lnk files which caused windows 7 to complain every time you open one. To fix go here: http://support.microsoft.com/?kbid=315933 to enable My Computer Security Zone Then go to Control Panel->Network and Internet->Internet Options You’ll see My Computer under the Security [...]

Got one of these badboys and loaded up linux and was greeted with a big “Unsupported Hardware” watermark. A little googling and i found this link: http://www.phoronix.com/forums/showthread.php?t=19875 The script is below ( i take no responsibly for you messing your system up ) #!/bin/sh DRIVER=/usr/lib/xorg/modules/drivers/fglrx_drv.so for x in $(objdump -d $DRIVER|awk ‘/call/&&/EnableLogo/{print “\\x”$2″\\x”$3″\\x”$4″\\x”$5″\\x”$6}’); do sed [...]

I once ran into an instance where the Unix admins didn’t believe me that i was running out of shared memory despite the errors, I was showing them. I wrote this perl script to allocate chunks of shared memory until it failed to prove to them that yes, regardless of what you have the global [...]

Sometimes you may see core dumps, etc related to lack of shared memory. To check to see how much is currently being used you can use the below command: kerrd@vexbert<10> ipcs -bm IPC status from as of Thu Oct 30 10:42:06 PDT 2008 T ID KEY MODE OWNER GROUP SEGSZ Shared Memory: m 1493172237 0x32d14fb8 [...]