http://www.booservers.com <p>cPanel requires Postgresql 7.3.x or later. 7.2.x will not work.</p><p>===========================================<br />Step 1<br />===========================================<br />Upgrade to cPanel 7.4.0 build 45 or later<br />===========================================</p><p>===========================================<br />Step 1a (If you do not have 7.2.x or earlier installed skip this step)<br />===========================================<br />Login to a root shell via ssh or the console.</p><p>If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method. </p><p>Move the postgres data directory somewhere else. ie</p><p>mv /var/lib/pgsql /var/lib/pgsql.old<br />===========================================</p><br/><center><script type="text/javascript"><!-- google_ad_client = "pub-7209259988091090"; google_ad_width = 300; google_ad_height = 250; google_ad_format = "300x250_as"; google_ad_type = "text_image"; google_ad_channel ="3498328464"; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "006633"; google_color_url = "000000"; google_color_text = "0033CC"; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></center><br><p>===========================================<br />Step 2<br />===========================================<br />Login to a root shell via ssh or the console and run</p><p>/scripts/installpostgres<br />===========================================</p><p>===========================================<br />Step 2a (skip this step if you are not upgrading from postgres 7.2 or earlier<br />===========================================<br />Restore your sql dump created with pg_dumpall or by some other method using psql or some other method<br />===========================================</p><p><br />===========================================<br />Step 3<br />===========================================<br />Login to Web Host Manager and choose &quot;Postgres Config&quot; under Server Setup.</p><p>Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.<br />===========================================</p><p><br />===========================================<br />Step 4<br />===========================================<br />Use the &quot;Postgres Config&quot; option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords<br />===========================================</p><p><br />===========================================<br />Step 5<br />===========================================<br />Login to cPanel and click on Postgres .. Enjoy!<br />===========================================</p> http://www.booservers.com/archivo/8_installing_postgresql_on_cpanel.html Thu, 15 Dec 2005 19:07:46 +0000