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.

Getting postgres to start up upon boot

Discussion in 'General Discussion' started by fishfreek, Mar 26, 2004.

  1. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    I noticed today thanks to an angry client that postgres was not starting up upon reboot.

    IMO it should be set to do this after running thru the rudimentary cpanel setup but it appears its not.

    So the question is this. How do I do it?
     
  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
    Modify postgresql.conf to accept tcp/ip connections and restart postgres. Then
    # service chkservd stop
    # cd /etc/chkserv.d
    # pico postgresql
    Add the following contents:
    Code:
    service[PostGreSQL]=5432,GET / HTTP/1.0,EFATAL..,/etc/init.d/postgresql restart 
    ctrl-x to save
    # service chkservd start
    Now it should restart anytime it goes down.
     
  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
    Make sure 5432 is open on your firewall, too.
     
  4. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
Loading...

Share This Page