The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql install fix

Discussion in 'General Discussion' started by laborspy, Jun 8, 2005.

  1. laborspy

    laborspy Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    This is a fix for the people that are having problems installing Postgresql when trying the normal way of /scripts/installpostgres and fails. The error normally looks like this.

    In my case I didn't have any Postgresql rpm's installed and each time I ran cpanel's script it failed. Check to see if Postgresql is installed already by
    #rpm -qa|grep postgres
    This should display nothing, if it does please stop this fix will not work for you.


    First goto a directoy that you can download things to example /downloads
    #wget ftp://ftp3.us.postgresql.org/pub/po.../redhat/rhel3/postgresql-7.4.5-2PGDG.i686.rpm
    #wget ftp://ftp3.us.postgresql.org/pub/po...t/rhel3/postgresql-devel-7.4.5-2PGDG.i686.rpm
    #wget ftp://ftp3.us.postgresql.org/pub/po...at/rhel3/postgresql-libs-7.4.5-2PGDG.i686.rpm
    #wget ftp://ftp3.us.postgresql.org/pub/po.../rhel3/postgresql-python-7.4.5-2PGDG.i686.rpm
    #wget ftp://ftp3.us.postgresql.org/pub/po.../rhel3/postgresql-server-7.4.5-2PGDG.i686.rpm
    *cPanel doesn't play well with some versions of Postgresql so I went with the version I know works.

    Now install the rpm's
    #rpm -ihv postgresql-libs-7.4.5-2PGDG.i686.rpm
    #rpm -ihv postgresql-devel-7.4.5-2PGDG.i686.rpm
    #rpm -ihv postgresql-python-7.4.5-2PGDG.i686.rpm
    #rpm -ihv postgresql-7.4.5-2PGDG.i686.rpm
    #rpm -ihv postgresql-server-7.4.5-2PGDG.i686.rpm
    *the python one might error out if you don't have python installed

    Clean up time to save space
    #rm postgresql-libs-7.4.5-2PGDG.i686.rpm
    #rm postgresql-devel-7.4.5-2PGDG.i686.rpm
    #rm postgresql-python-7.4.5-2PGDG.i686.rpm
    #rm postgresql-7.4.5-2PGDG.i686.rpm
    #rm postgresql-server-7.4.5-2PGDG.i686.rpm

    Then run the install postgre with Cpanel for your customers
    #/scripts/installpostgres
    #Are you sure you wish to proceed? y [ENTER]


    Now goto your WHM page so we can configure Postgresql

    -login to http://yourdomain.com:2087

    -Section Service Configuration

    -Click on Postgres Config

    -Next Click Install Config

    -Then again Click on Postgres Config in Service Configuration

    -Type your password and click Change Password

    Thats it...your all done. If you login now to any cPanel you'll see the Postgresql icon
     
    #1 laborspy, Jun 8, 2005
    Last edited: Jun 8, 2005
  2. laborspy

    laborspy Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    Forgot something folks. If you do not follow this your PHP will not have access to Postgresql.

    -login to http://yourdomain.com:2087
    -Section Service Configuration
    -Select "Update Apache"
    -Now select all the functions for PHP that you want and make sure you include "Postgresql"
     
  3. laborspy

    laborspy Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    This script will install Postgres 7.3.x or later
    If you have an older version installed you wil need to
    Just did this on a buddies server and it worked there....above is the exact error message he was getting.
     
  4. Jason Brice

    Jason Brice Active Member

    Joined:
    Sep 29, 2001
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Does anyone notice that CPanel is sluggish to load after installing postgre?

    CPanel takes ages to load after the l/p is entered, but once it's loaded the CPanel operates as normal. Puzzling.
     
  5. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Are you sure that this isn't the often seen "slow cPanel login" issue which you can find discussed by searching for that string of words? :)
     
  6. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    any idea how todo that on freebsd ?

    also is it better to install /usr/ports/postgresql81-server or /usr/ports/postgresql74-server ?
     
Loading...

Share This Page