Changing (forgotten) PostgreSQL password

PostgreSQLWhether you lost password for postgres user or you'd just like to change it, the process is very simple. Unlike resetting lost password for MySQL's root user, resetting postgres' password is pretty straightforward and you'll not experience any kind of downtime. This article explains how to change/reset password for postgres user in PostgreSQL 8.4 server that runs on CentOS 5.7, but I've thrown in some tips to help you out if you're using Debian or Ubuntu Linux distro.


Running Django in virtualenv

PythonSo, you learned some Python, heard a thing or two about Django framework and decided to try it out. You're in luck, because you can set up your development environment in less then 60 seconds.

The idea is that you install and run Django within virtualenv. If you wonder what is virtualenv and why you should use it, the answer is simple. Virtualenv is a tool to create isolated Python environments. If you develop your Python application within virtual environment, you don't have to worry about bloating your system with various Python modules or choosing between AppA which requires PythonLib 1.0 and AppB which requires PythonLib 2.0. With virtualenv, you have clean Python environment in which you can install whatever Python module you'd like.