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.

postgres won't restart automagically

Discussion in 'General Discussion' started by onaweb, Oct 19, 2004.

  1. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Hello,
    I finally got postgres running, but the problem I'm having is that when it attempts to restart automagically, it doesn't. I have to access the server via shell and run
    service postgres stop
    su postgres
    /usr/bin/postmaster -D /var/lib/pgsql/data -i
    and it will start but I receive this error message
    FATAL: invalid length of startup packet

    everything appears to run fine after that but if the server goes down it won't restart.

    Any ideas?

    Thanks,
    Andy
     
  2. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    Make sure you manually update your pgsql.conf file so that the tcp socket is enabled.
     
  3. onaweb

    onaweb Well-Known Member

    Joined:
    Jan 1, 2004
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    Yep. That's all done. It does monitor postgresql and attempt to restart it, but it can't.

    I should also mention that I have uninstalled and installed postgres several times and still receive the same problem.

    I also noticed that in my Service Status, I have 2 postgresql - one in lower case and one in upper case.

    PostGreSQL up
    apache (1.3.31 (Unix)) up
    bind (9.2.1) up
    cppop up
    cpsrvd up
    exim (exim-4.43-0_cpanel_stmpcontrol_antivirus_rewrite_mailman2_maskedmailtrap_exiscan) up
    eximstats up
    ftpd up
    imap up
    mysql (4.0.20-standard) up
    postgresql up
    syslogd up
    Server Load 0.27 (1 cpu)
    Memory Used 24.4 %
    Swap 0.819 %
    Disk hda3 (/) DMA+ 12 %
    Disk hda1 (/boot) DMA+ 10 %
    Disk hdc1 (/backup) DMA+ 13 %

    Thanks for your help though.
    Andy
     
Loading...

Share This Page