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 can't find postmaster.pid

Discussion in 'General Discussion' started by Arvand, Sep 17, 2003.

  1. Arvand

    Arvand Well-Known Member
    PartnerNOC

    Joined:
    Jul 26, 2003
    Messages:
    130
    Likes Received:
    1
    Trophy Points:
    18
    Hello,

    I first tried /scripts/installpostgres but it said RPMs existed and the service wouldn't start. So I removed the rpms and tried the script again. It still wouldn't start ([Failed]). And of course just like everything else that doesn't work it writes nothing usefull to the logs so I had no idea why it wasn't working. When I used WHM to install the pgsql config file it gave this error:

    Setting up Postgres Config...Done
    Reloading Postgres...pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid
    Is postmaster running?
    Done

    The Postgres config install has been completed.

    If i understand correct. Postmaster comes with the pgsql server rpm. Why does it not go there on my server?

    Thank you,

    Arvand Sabetian

    cPanel.net Support Ticket Number:
     
  2. Arvand

    Arvand Well-Known Member
    PartnerNOC

    Joined:
    Jul 26, 2003
    Messages:
    130
    Likes Received:
    1
    Trophy Points:
    18
    no body even tried installing postgresql?

    cPanel.net Support Ticket Number:
     
  3. ahaley

    ahaley Member

    Joined:
    Oct 6, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hi
    Hope this is not too late for any use for you, but I just had exactly the same problem and my hosting co helped me - this is what to do:

    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


    cPanel.net Support Ticket Number: :cool:

    cPanel.net Support Ticket Number:
     
  4. Website Rob

    Website Rob Well-Known Member

    Joined:
    Mar 23, 2002
    Messages:
    1,506
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    Alberta, Canada
    cPanel Access Level:
    Root Administrator
    In 'root' WHM >> Restart Services - one should see: Postgresql Server. If not there it is probably not installed. Easiest method is to use WHM >> Software >> Install an RPM >> postgresql

    The big tip-off is, if it doesn't say (reinstall) then it is not installed.

    Don't know why the reference made to /var/lib/pgsql as I have not found that path under any of the Servers I manage -- even though Postgrsql is installed and functional?


    Edit: seems I jumped the gun a bit. A locate for postmaster.pid returned nothing and cannot log into phpPgAdmin. Seems a Search for more info is in order. ;)


    Edit: easier than I thought. After the above one must go back and RPM install postgresql-server. All worked fine after that.
     
    #4 Website Rob, Oct 7, 2003
    Last edited: Oct 8, 2003
Loading...

Share This Page