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 PostgreSQL Version?

Discussion in 'Database Discussion' started by jlucho, Dec 14, 2018.

Tags:
  1. jlucho

    jlucho Well-Known Member

    Joined:
    Aug 5, 2006
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    Hello friends

    I use Linux centos + CloudLinux + cPanel v76.0.14

    What is the latest version of PostgreSQL for this version?

    my current version of postgresql is:
    [[email protected] ~]# postgres --version
    postgres (PostgreSQL) 8.4.20


    what is the procedure to update postgresql, to the latest version in force
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @jlucho,

    We only support versions of PostgreSQL that you install with the /usr/local/cpanel/scripts/installpostgres script. This script installs the version of PostgreSQL offered with your operating system.

    Can you let me know which version of CloudLinux is installed on your system? You can check by running the following command:

    Code:
    cat /etc/redhat-release
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. jlucho

    jlucho Well-Known Member

    Joined:
    Aug 5, 2006
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    [[email protected] ~]# cat /etc/redhat-release
    CloudLinux Server release 6.10 (Vladimir Lyakhov)
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,528
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @jlucho,

    The version of PostgreSQL installed on the system is dictated by what your OS provides. PostgreSQL version 8.4 is provided with CloudLinux/CentOS 6. To use a newer version (e.g. 9.2) in a supported fashion, you'd need to setup a new server using CentOS/CloudLinux version 7, and transfer your accounts over to the new server.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. jlucho

    jlucho Well-Known Member

    Joined:
    Aug 5, 2006
    Messages:
    56
    Likes Received:
    1
    Trophy Points:
    158
    whats is last version stable of PostgreSQL for cPanel/Centos 6.9 ??

    whats is last version stable of PostgreSQL for cPanel/Centos 7.x ??
     
  6. dalem

    dalem Well-Known Member PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,909
    Likes Received:
    127
    Trophy Points:
    368
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    centos 7 postgresql.x86_64 9.2.24-1.el7_5
    centos 6 postgresql.x86_64 8.4.20-8.el6_9

    a yum list would have given you the info
     
    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