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:
    900
    Likes Received:
    0
    Trophy Points:
    16
    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:
     
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    16
    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:
     
  3. ahaley

    ahaley Member

    Joined:
    Oct 6, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    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:
     
Loading...

Share This Page