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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
     
    #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. IdleServ

    Failed to determine postgresql version

    IdleServ, Apr 17, 2018, in forum: Database Discussions
    Replies:
    19
    Views:
    102
    cPanelLauren
    Apr 18, 2018
  2. mindnetcombr

    Postgresql error pktacct/transfer tool

    mindnetcombr, Jan 13, 2018, in forum: Database Discussions
    Replies:
    2
    Views:
    181
    cPanelMichael
    Jan 18, 2018
  3. Kent Brockman

    How to completely disable PostgreSQL

    Kent Brockman, Dec 26, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    328
    cPanelMichael
    Dec 27, 2017
  4. benhuragmf

    Failed to start the postgresql service

    benhuragmf, Sep 20, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    729
    cPanelMichael
    Sep 20, 2017
  5. Mulyawan Sentosa

    Blind SQL Injection in PostgreSQL

    Mulyawan Sentosa, May 27, 2017, in forum: Security
    Replies:
    3
    Views:
    402
    cPanelKenneth
    May 30, 2017

Share This Page