Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Jan 2004
    Posts
    76

    Default postgres won't restart automagically

    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. #2
    Member
    Join Date
    Jul 2002
    Location
    Atlanta, GA
    Posts
    646

    Default

    Make sure you manually update your pgsql.conf file so that the tcp socket is enabled.

  3. #3
    Member
    Join Date
    Jan 2004
    Posts
    76

    Default

    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

Similar Threads & Tags
Similar threads

  1. Replies: 2
    Last Post: 04-25-2011, 05:36 PM
  2. mysql failed @ Thu Aug 26 17:42:09 2010. A restart was attempted automagically.
    By phantom_277 in forum cPanel and WHM Discussions
    Replies: 9
    Last Post: 09-07-2010, 11:49 AM
  3. Replies: 1
    Last Post: 03-18-2008, 09:39 AM
  4. exim failed @ A restart was attempted automagically.
    By pkuk in forum E-mail Discussions
    Replies: 0
    Last Post: 12-03-2007, 04:15 PM
  5. Cpanel 6.0 Stable Version Automagically Restart
    By xp2u in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 03-18-2003, 11:33 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube