Moving PostgreSQL database to different name is pretty hard compared to MySQL. But here’s how you do it:

$ pg_dump --no-acl --no-owner -U <username> -h <host> -Fc <database> > <dump filename>
$ pg_restore -1 -c -U <username> -d <database> -h <host> --no-owner <dump filename>

$ pg_dump --no-acl --no-owner -U old -h 127.0.0.1 -Fc olddb > old.dump
$ pg_restore -1 -c -U newuser -d newdb -h postgresql.lan --no-owner old.dump

If you’re familiar with Windows XP Service Pack slipstreaming, this is pretty similar.

I’m using Windows XP Professional for this.

Make ISO image from your Windows 7 DVD with your favorite software. I used CDBurnerXP.

Save install.wim somewhere on your hard drive from that ISO image or straight from DVD.

Download Windows Automated Installation Kit for your OS.

Start AIK Deployment Tools Command Prompt

cd <path where you saved that wim file>

Mount the WIM image with write permissions:
imagex will tell which number is which Windows edition if it’s not found. I tried it first with just number 0.
Number 4 is in this case Windows 7 Ultimate Edition 64 bit.

imagex /mountrw install.wim 4 c:\wim

add as many drivers as you like by using DISM
if dism says that files are essential for booting but drivers are unsigned, then add /forceunsigned parameter.

Here’s example for nvidia nforce drivers (Installer EXE extracted with 7-zip):
SATA/SATARAID/IDE/Ethernet/etc drivers:

cd c:\dl\15.51_nforce_win7_64bit_whql\ide\win764\
dism /image:c:\wim /add-driver /driver:. /recurse

cd c:\dl\15.51_nforce_win7_64bit_whql\smbus
dism /image:c:\wim /add-driver /driver:. /recurse /forceunsigned

cd c:\dl\15.51_nforce_win7_64bit_whql\smu
dism /image:c:\wim /add-driver /driver:. /recurse

cd c:\dl\15.51_nforce_win7_64bit_whql\ethernet
dism /image:c:\wim /add-driver /driver:. /recurse

..and so on for all needed drivers..

You will need to expand unexpanded driver files in some cases. Drivers are not expanded if filenames in driver directory are foo.dl_ and not foo.dll etc.

Here’s NVidia GeForce driver sample for you (Installer EXE extracted with 7-zip)

cd c:\dl\191.07_desktop_win7_winvista_64bit_international_whql
mkdir c:\displaydriver
expand *.* c:\displaydriver

and then

cd c:\displaydriver
dism /image:c:\wim /add-driver /driver:. /recurse

Save the WIM image with new drivers:

unmount and commit (commit = save)

imagex /unmount /commit c:\wim

Add the install.wim back to the ISO image with your favorite ISO handling software. I used UltraISO.
Make sure that the DVD is bootable. Burn ISO as new DVD yet again with favorite burning software (CDBurnerXP).
Boot and enjoy your new Windows 7 with correct and working drivers.

Here’sfew plugins for Trac:

Timing and Estimation Plugin

Project manager, CEO and customer are usually not interested in count of tickets. This plugin adds new fields to tickets where you can add hour estimations and actual worked hours. It also adds checkbox for billable/not billable ticket.

Homepage

Batch modification of tickets

I found this useful when you have for example milestone Preview1 and all tickets are there. Then you release the Preview1 version. Next you create Preview2 milestone and move all open tickets from Preview1 to Preview2. No need to modify every ticket, only make a custom query and select all open tickets.

Homepage

My computer was getting slow and I found the culprit: fragmented harddrive. So as a Super User™ I searched for better defragmentation software than Windozes own and found software called MyDefrag.

So why it’s so much better alternative than OS’s own built-in software? You can script it! It also runs as a screensaver. So I’m now getting average of 8 hours of defragmentation per day. That should keep harddrive fragmentation in order.