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.

Centos Cpanel install postgresql 9

Discussion in 'Database Discussions' started by Saytik, Oct 22, 2013.

  1. Saytik

    Saytik Member

    Joined:
    Jul 2, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Hello.
    WHM 11.38.2 (build 7)
    Centos 5.10

    I have installed pgsql repo http://yum.pgrpms.org/9.3/redhat/rhel-5-x86_64/pgdg-centos93-9.3-1.noarch.rpm
    for postgresql 9.3
    I have added exclude=postgresql* to yum to exclude postgresql 8.

    Then i have run /scripts/installpostgresql
    The follofing symlinks where created for old directory structure:
    Code:
    ln -s /var/lib/pgsql/9.3/backups/ /var/lib/pgsql/
    ln -s /var/lib/pgsql/9.3/data/ /var/lib/pgsql/
    ln -s /etc/init.d/postgresql-9.3 /etc/init.d/postgresql
    
    Init database:
    Code:
    service postgresql initdb
    Initializing database:
    
     /etc/init.d/postgresql restart
    Stopping postgresql service:                               [  OK  ]
    Starting postgresql service:                               [  OK  ]
    
    And now i can't find function "Configure Postgres" in WHM ... Please help me
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The following guide was provided on our Edge-Users list in regards to configuring PostgreSQL 9.2. Please note this method is not supported directly by cPanel, and only offered as guidance to a manual workaround. You will need to modify these instructions if you want to use version 9.3 instead of 9.2:

    Thank you.
     
  3. Saytik

    Saytik Member

    Joined:
    Jul 2, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Thank you.
    Code:
     cd /usr/pgsql-9.3/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done
    
    that helped.



    Also, from this link
    whereis your own packaged version of PostgreSQL ? ;)
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I don't have any new information to report on this at this time. It still looks to be in the planning phase.

    Thank you.
     
Loading...

Share This Page