Upgrade Postgresql

# remove old packages
yum erase postgresql postgresql-server

# install new version postgresql
yum install -y postgresql84 postgresql84-server
rm -rf /var/lib/pgsql/data/*
initdb -d /var/lib/pgsql/data

Reference: study-area.org