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.

Upgrade Postresql from 8.4 to 9.2

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

  1. Phincy

    Phincy Member

    Joined:
    Feb 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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:
    255
    Likes Received:
    2
    Trophy Points:
    18
    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:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    INDIA
    cPanel Access Level:
    Root Administrator
    Twitter:
    Thank you so much!!!

    Its working fine for us.


     
Loading...

Share This Page