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 has failed

Discussion in 'General Discussion' started by jason32, Oct 13, 2004.

  1. jason32

    jason32 Member

    Joined:
    Oct 13, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I have read many other threads on a similar topic to this but none of them have helped.

    A few days ago I started receiving the following email notification every 10 minutes:
    "postgresql failed @ Wed Oct 13 16:42:56 2004. A restart was attempted automagicly."

    When I try to restart postgresql manually using WHM 9.9.0 I get the following error message:
    "postgresql has failed, please contact the sysadmin (result was "postmaster is not running"). "

    The contents of my /etc/chkserv.d are:
    service[postgresql]=x,x,x,/scripts/restartsrv postgresql,postmaster,pgsql|postgres|root

    I have read somewhere that I might be able to solve the problem by finding the 'postmaster.pid' file somewhere in a postgres data directory and delete it.

    The only problem is that I can't even find where postgress is installed - I've searched all partitions for 'postgresql', 'postgres', and 'pgsql' but all I can find are the docs and install files but not the actual installation.

    Can someone please tell me where I might find the installation of postgress, or tell me another solution to the problem.

    Thank you,
    Jason.
     
  2. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    What do you want to do? Uninstall it to make the message go away or fix it to make the message go away? Either way, the answer is here on the forums.
     
  3. jason32

    jason32 Member

    Joined:
    Oct 13, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hello Casey,

    Thank you for your reply.

    What I want to do is fix postgresql so that it works properly and makes the message go away.

    I spent several hours searching through the forums here and I have not found the answer - please point me in the right direction if you can.

    Thank you,
    Jason.
     
  4. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    38
    Type this line from your original post into a search and spend a few minutes more :cool: :

    postgresql has failed please contact the sysadmin



    You can leave out 'has', 'please' and 'the' if you would like. cPanel search sees those as noise words.
     
  5. jason32

    jason32 Member

    Joined:
    Oct 13, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thank you SarcNBit,

    With your help I did find a new thread that I hadn't previously read, and now I'm starting to suspect that Postgres is not installed.

    For example when I look where I think it should be this is what happens:

    ls -l /var/lib/pgsql
    /var/lib/pgsql: No such file or directory

    In fact I have nothing in /var/lib/ that looks like postgres.

    Can anyone please tell me if this means it's not installed, or let me know a definitive way to find out if it is or not?

    Thank you,
    Jason.
     
  6. Sheldon

    Sheldon Well-Known Member

    Joined:
    Jun 7, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Canada
    /scripts/reinstallpostgres

    expect to loose any db's if you had any to begin with. ... you may have already lost them.. I dont know.

    Sheldon
     
  7. Ben

    Ben Well-Known Member

    Joined:
    Aug 19, 2002
    Messages:
    77
    Likes Received:
    0
    Trophy Points:
    6
    Or, if you don't want pgsql at all, just uncheck it from the service manager and run

    service chkservd restart

    from the command line.
     
  8. jason32

    jason32 Member

    Joined:
    Oct 13, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thank you for the follow-ups, but I'm still not sure if postgres is actaully installed.

    If it is, I'll fix it. If it isn't then I'll remove it from the service manager.

    Can someone please tell me how to confirm whether or not Postgres is installed?

    Thank you,
    Jason.
     
  9. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    If there are no folders on your server entitled pgsql then it is not installed.
     
  10. jason32

    jason32 Member

    Joined:
    Oct 13, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thank you casey,

    I do have some pgsql directories but they are either empty or seem to include only source files - the directories are:

    /usr/lib/pgsql <- one subdir but no files
    /usr/include/pgsql <- seems to include only source files
    /usr/local/cpanel/3rdparty/interchange/foundation/dbconf/pgsql/ <- seems to include only Cpanel config files.

    Does this mean postgres is not installed?

    Thanks in advance,
    Jason.
     
  11. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Regardless, run the following:
    /scripts/installpostgres
     
  12. webJ

    webJ Active Member

    Joined:
    Apr 9, 2003
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    I'm having this same problem, but I have no /scripts/reinstallpostgres. I do have a /scripts/installpostgres but that prouduces errors and does not finish successfully. Should I uninstall postgre then run it? If so how to uninstall?
     
Loading...

Share This Page