How to install RDBMS PostgreSQL (alternative to MySQL and SQLite)

Searching through the forum could not find any HOWTO on PostgreSQL installation. For those who's interested here is the tutorial.