FreeBSD

sudo pkg install postgresql96-server

echo "postgresql_enable=\"YES\"" >> /etc/rc.conf
sudo service postgresql initdb
sudo service postgresql start

WARNING:

If you are running postgresql in a jail, you'll need to enable sysvipc

# /etc/jail.conf
jailname {
	...
	allow.sysvipc;
}

Ubuntu

sudo apt-get install postgresql