How to install PostgreSQL on FreeBSD/PCBSD

In this tutorial I want to share to you on how to install PostgreSQL v8.4.3 on FreeBSD/PC-BSD. This tutorial should be applicable on other BSD families (NetBSD, OpenBSD) and Linux distros (Slackware, Centos, Ubuntu, Redhat, Debian, etc) because we will install PostgreSQL from source distribution file.

PC-BSD 8.0 Screenshots

PC-BSD 8.0 (Hubble Edition) that announced at 22 February last month is the latest release of PC-BSD. It's been built based-on FreeBSD 8.0. Many improvements and enhancements have been added to it such as brand new System Installer,  KDE 4.3.5 Desktop System, support for 3D acceleration with NVIDIA drivers on amd64 and more.