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.

Monitoring for PostgreSQL status

Discussion in 'General Discussion' started by JPmorgan, Aug 29, 2003.

  1. JPmorgan

    JPmorgan BANNED

    Joined:
    Aug 19, 2003
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    6
    Anyone know what the proper commands are for this?

    #SERVICE = PORT, SEND, RESPONSE, RESTART COMMAND

    service[PostGreSQL]=5432,GET / HTTP/1.0,EFATAL..,/etc/init.d/postgresql restart

    Dgbaker posted this awhile back but i cant get it to work. It still red after 10min. How can we monitor for postgresql?

    Thanks

    cPanel.net Support Ticket Number:
     
  2. JPmorgan

    JPmorgan BANNED

    Joined:
    Aug 19, 2003
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    6
    Fixed, got it!

    PostgreSQL up GREEN

    cPanel.net Support Ticket Number:
     
  3. 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
    Re: Re: Monitoring for PostgreSQL status

    What is the proper code?

    cPanel.net Support Ticket Number:
     
  4. 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
    Found it:
    Code:
    #SERVICE = PORT, SEND, RESPONSE, RESTART COMMAND
    
    service[postgresql]=x,x,x,/scripts/restartsrv postgresql,postmaster|postmaster,postgres|root
    
    cPanel.net Support Ticket Number:
     
  5. 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
    Don't use that. It doesn't restart postgres when it stops. It just shows you a pretty green light even though it is down. Modify postgresql.conf to allow tcpip connections, restart postgres and then add the first code mentioned, i.e.
     
Loading...

Share This Page