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.

Postgre SQL - Install

Discussion in 'Database Discussions' 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:
    16
    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:
    1
    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:
    36
    Location:
    If there is trouble, it will find me
    /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:
    16
    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:
    1
    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:
    36
    Location:
    If there is trouble, it will find me
    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:
    36
    Location:
    If there is trouble, it will find me
    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:
    16
    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,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

Share This Page