Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Upgrade Postresql from 8.4 to 9.2

Discussion in 'Database Discussion' started by Phincy, Apr 20, 2013.

  1. Phincy

    Phincy Member

    Joined:
    Feb 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Hi,

    I am trying to upgrade the PostGreSQL server from 8.4 to 9.2. I tried to follow the steps mentioned in the following URL(it is for version 9.1, but I am correcting my steps according to 9.2) but now the WHM/cPanel is not even showing the PostgresQL.

    Install PostgreSQL 9 on cPanel : David Ghedini

    Any ideas?

    ---
    root@host [~]# rpm -qa | grep -i postgre
    cpanel-postgresql-9.0.8-1.cp1136.i386
    postgresql92-9.2.4-1PGDG.rhel6.i686
    cpanel-postgresql-libs-9.0.8-1.cp1136.i386
    postgresql92-server-9.2.4-1PGDG.rhel6.i686
    postgresql92-devel-9.2.4-1PGDG.rhel6.i686
    postgresql92-libs-9.2.4-1PGDG.rhel6.i686
    postgresql92-contrib-9.2.4-1PGDG.rhel6.i686
    root@host [~]#
    ---
    root@host [~]# /etc/init.d/postgresql-9.2 status
    (pid 24097) is running...
    root@host [~]#
    ---
     
  2. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    261
    Likes Received:
    4
    Trophy Points:
    68
    cPanel Access Level:
    DataCenter Provider
    Hello,

    Try this:
    Code:
    cd /usr/pgsql-9.2/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
    
    cd /var/lib/pgsql; ln -s 9.2/backups; ln -s 9.2/data; ln -s 9.2/pgstartup.log
     
  3. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thank you so much!!!

    Its working fine for us.


     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice