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!

Postgre SQL - Install

Discussion in 'Database Discussion' started by bmcpanel, Aug 12, 2003.

Thread Status:
Not open for further replies.
  1. bmcpanel

    bmcpanel Well-Known Member

    Joined:
    Jun 1, 2002
    Messages:
    546
    Likes Received:
    0
    Trophy Points:
    316
    I do not use and am not familiar with Postgre. However, I have a customer who wants to use it and I notice in the X theme, there is a place to install Postgre SQL.

    However, I do not know how to get it up and going. Instead, I get this error when attempting to install a db via the custoemr control panel.

    No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

    AND, the phpPGMyADmin link gives this error....

    >>>> Configuration error: Copy conf/config.inc.php-dist to conf/config.inc.php and edit appropriately.

    Is the Postgre SQL feature and phpPGMyAdmin not yet ready? Can anyone help this Postgre newcomer (me)?

    Thanks.

    cPanel.net Support Ticket Number:
     
    #1 bmcpanel, Aug 12, 2003
    Last edited: Aug 12, 2003
  2. ehost

    ehost Member

    Joined:
    Jul 7, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    I got the same error message

    cPanel.net Support Ticket Number:
     
  3. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    /scripts/installpostgres

    To fix the error with phpPgAdmin, go to /usr/local/cpanel/base/3rdparty/phpPgAdmin and rename conf/config.inc.php-dist to conf/config.inc.php

    cPanel.net Support Ticket Number:
     
    #3 casey, Aug 13, 2003
    Last edited: Aug 13, 2003
  4. hormigo

    hormigo Well-Known Member

    Joined:
    Sep 9, 2002
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    166
    casey, are you running postgres fine?

    I have this error

    Database Created
    Added the database ´test. Password: psql: FATAL 1: Password authentication failed for user "postgres"

    cPanel.net Support Ticket Number:
     
  5. ehost

    ehost Member

    Joined:
    Jul 7, 2003
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Code:
    root@ns1 [/etc/rc.d/init.d]# /scripts/installpostgres
    installed: postgresql-server-7.2.3-5.73
    installed: postgresql-7.2.3-5.73
    Initializing database:                                     [FAILED]
    Starting postgresql service:                               [FAILED]
    
    cPanel.net Support Ticket Number:
     
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    Nope. I have the same error.:(

    cPanel.net Support Ticket Number:
     
  7. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    Try this:

    # rpm -qa | grep postgres
    Delete everything that appears with the following command:
    # rpm -e postgresql-server-7.2.3-5.73 postgresql-7.2.3-5.73 (and anything else, all on one line)
    # rm -rf /var/lib/pgsql/data
    # /scripts/installpostgres

    cPanel.net Support Ticket Number:
     
  8. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    166
    These people are nuts!!!!!!!!!!

    I ran thought the installpostgresql installation for the 20th time. It installs the following version;

    Building local rpm provides list...Done
    Adding Dependency postgresql-libs (required by postgresql-server)
    Adding Dependency postgresql (required by postgresql-server)
    postgresql: not installed.
    postgresql-libs: not installed.
    postgresql-server: not installed.
    Retrieving http://updates.cpanel.net/redhat/updates/7.3/en/os/i386/postgresql-7.2.3-5.73.i386.rpm
    Retrieving http://updates.cpanel.net/redhat/updates/7.3/en/os/i386/postgresql-libs-7.2.3-5.73.i386.rpm
    Retrieving http://updates.cpanel.net/redhat/updates/7.3/en/os/i386/postgresql-server-7.2.3-5.73.i386.rpm
    Preparing... ########################################### [100%]
    1:postgresql-libs ########################################### [ 33%]
    2:postgresql ########################################### [ 66%]
    3:postgresql-server ########################################### [100%]
    Rebuilding local rpm provides list.....postgresql....postgresql-libs....postgresql-server..Done


    Then there is a new option that says the following from WHM!

    Postgres Config

    I take the option and click OK and i see this!!!!

    Setting up Postgres Config...You are running an old unsupported postgresql version.
    cPanel only supports postgres 7.3.x or better. :confused: :confused: :confused:

    So if they only support 7.3.2 why is their updater installing 7.2.3???

    Great logic. Use their update program that installs somekind of outdated version! :rolleyes:

    cPanel.net Support Ticket Number:
     
  9. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    30
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

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