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!

Postgresql Won't work

Discussion in 'General Discussion' started by GOT, Sep 2, 2003.

  1. GOT

    GOT Get Proactive!

    Joined:
    Apr 8, 2003
    Messages:
    902
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Norfolk, VA
    cPanel Access Level:
    DataCenter Provider
    Tried installing postgresql today, and it is not working for some reason:

    root@server2 [/usr/local/apache]# /scripts/installpostgres
    This script will install Postgres 7.3.x or later
    If you have an older version installed you wil need to
    Dump your databases to a file and then restore them
    after the install as 7.3.x is not backwards compatible.
    If you do not have any databases, you can just run:
    mv /var/lib/pgsql /var/lib/pgsql.old
    /sbin/service postgresql stop
    /sbin/service postgresql start
    to force creating a 7.3.x style setup. Do not do this if
    you have databases that you wish to keep!

    Are you sure you wish to proceed? yes
    Fetching rpm updates list...Done
    Fetching rpm provides list...Done
    Fetching rpm requires list...Done
    Building local rpm provides list...Done
    Adding Dependency postgresql (required by postgresql-server)
    postgresql: not installed.
    postgresql-server: not installed.
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-7.3.3-1PGDG.i386.rpm
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-server-7.3.3-1PGDG.i386.rpm
    Preparing... ########################################### [100%]
    1:postgresql ########################################### [ 50%]
    2:postgresql-server ########################################### [100%]
    Rebuilding local rpm provides list.....postgresql....postgresql-server..Done
    postgresql: installed version 7.3.3-1PGDG is up to date, no action needed.
    postgresql-devel: not installed.
    Retrieving http://updates.cpanel.net/postgres/v7.3.3/redhat-7.3/postgresql-devel-7.3.3-1PGDG.i386.rpm
    Preparing... ########################################### [100%]
    1:postgresql-devel ########################################### [100%]
    Rebuilding local rpm provides list.....postgresql-devel..Done
    [FAILED]
    postmaster: no process killed
    postmaster: no process killed
    Starting postgresql service: [FAILED]
    root@server2 [/usr/local/apache]#

    I thought I had had this working at one point, but I noticed it was not running today, so I removed all postgresql rpms and tried to start from scratch, but this is what I get.

    Any thoughts?

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 GOT, Sep 2, 2003
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    166
    RE: Postgresql Won

    Dear GotHosting,

    Check the postmaster\'s log file, or start postmaster service in command prompt to see whether postmaster is installed properly in server and also find out what complaint messages appear.

    If the postgresql got installed and if there is only problem in start up of postmaster service then starting the service in command prompt will help to find the exact error message you get.

    Also, check for any postmaster service already running using ps -aux command if it is running then kill that service before trying reinstallation.

    Regards,

    cPanel.net Support Ticket Number:
     
    #2 mickeymouse, Sep 23, 2003
  3. ahaley

    ahaley Member

    Joined:
    Oct 6, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    Is Postmaster Running?

    Hi
    This is what I did to get it fixed on my server:

    login to ssh as root:

    mv /var/lib/pgsql /var/lib/pgsql.old

    then run the postgre install again under ssh:

    /scripts/installpostgres

    then log into your WHM admin and click on the Postgre Config and reconfig and then change your password and all should be working.

    Regards
    Andrew Haley
    :cool:

    cPanel.net Support Ticket Number:
     
    #3 ahaley, Oct 7, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Postgresql Won't
  1. emmawatson8855

    Which Script Installs PostgreSQL on a cPanel & WHM server?

    emmawatson8855, Jun 25, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    95
    cPanelMichael
    Jun 25, 2018
  2. kuttysam

    Failed to start postgresql service

    kuttysam, Jun 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    158
    cPanelLauren
    Jun 7, 2018
  3. IdleServ

    Failed to determine postgresql version

    IdleServ, Apr 17, 2018, in forum: Database Discussion
    Replies:
    21
    Views:
    358
    cPanelLauren
    Aug 6, 2018
  4. mindnetcombr

    Postgresql error pktacct/transfer tool

    mindnetcombr, Jan 13, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    236
    cPanelMichael
    Jan 18, 2018
  5. Kent Brockman

    How to completely disable PostgreSQL

    Kent Brockman, Dec 26, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    595
    cPanelMichael
    Dec 27, 2017

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.
    Accept Learn More...
    Dismiss Notice