For those planing to use PostgreSQL, you can download the Free EnterpriseDB studio which is a good application for management of PostgreSQL.
<div><br></div><div>It is not advisable to install PostgreSQL using your distribution installers such as yum and apt-get. This is because PostgreSQL will be automatically upgraded , and this changes the database version ; at the moment, database versions are not backwards compatible and you have to manually transfer your data from one database version to another. </div>
<div><br></div><div>that is why its easier and better to use EnterpriseDB</div>