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.

Postgresql fails after 10.0.0 upgrade

Discussion in 'General Discussion' started by alteredsanity, Jan 26, 2005.

  1. alteredsanity

    alteredsanity Member

    Joined:
    Mar 23, 2004
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    After the upgrade, Postgresql is red lighted as failing in WHM and cPanel. Heres one of my issues, I did not have it installed before or enabled in Service Manager..? I had no need for it so I did not have it running, so why the problem?
    I looked in the forums for some help and one suggestion was to install it from /scripts/installpostgres to try to make it stop failing. I did that, then also enabled it in Service Manager and restarted the Postgres server.
    The failed red in WHM is still there even IF I have the Service Manager option enabled for Postgres, if I uncheck it, it goes green in Server Status. But NO Matter what, in cPanel it will stay failed.

    Any Ideas?
     
  2. nettigritty

    nettigritty Well-Known Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    194
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore, India
    try upgrading postgres. should help. search the forum for a howto
     
  3. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    To get rid of it try this.

    In ssh
    cd /var/run/chkservd
    rm PostGreSQL <-- or similar name

    cd /etc/chkserv.d
    rm postgres <-- or similar name

    service chkservd restart

    That should remove the warning. NOTE: This for only if you do not have PostGreSQL and do not want it.
     
  4. XPerties

    XPerties Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    401
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    New Jersey, USA

    Going off this how would you insure it's not on and running/installed on your system?

    In other words how would you un-install it completely form your machine?
     
  5. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    If not sure if running or installed, then do this first

    Is it running?
    ps -ef |grep postmaster

    Is it installed?

    ls /usr/local/pgsql/bin/postmaster

    If either of those give an true answer then it is at the very minimum installed if not running.

    To uninstall see this thread http://forums.cpanel.net/showthread.php?t=28533&highlight=PostGre
     
    #5 dgbaker, Feb 4, 2005
    Last edited: Feb 4, 2005
  6. XPerties

    XPerties Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    401
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    New Jersey, USA
    postgres 1446 1 0 Jan17 ? 00:00:01 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
    root 3522 2276 0 16:02 pts/2 00:00:00 grep postmaster


    I followed the thread on how to remove it but I got "package postgresql is not installed" on all 4 commands in that thread.
     
Loading...

Share This Page