Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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 is stopped

Discussion in 'Database Discussions' started by urgido, Apr 4, 2018.

  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    97
    Likes Received:
    5
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    I got this error on my mailbox so, I did a searching into /var/log/messages but nothing stranger to show.
    This is the only input related with "postgresql".

    I tried the follow steps: Problem with /usr/local/cpanel/scripts/update_db_cache but no luck

    So, I did the most simple thing I restarted the service from WHM interface and all go like a charm. Any clue ot this problem?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    428
    Likes Received:
    29
    Trophy Points:
    103
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    I'm happy to see you were able to get it started. I can't speak for the specific error you were experiencing but PostgreSQL by default when installed on cPanel logs to /var/lib/pgsql/data/pg_log and it's possible checking here may provide some further insight on what occurred.

    Looking in the thread you mentioned it does appear to have been an issue with MySQL which was addressed in cPanel v11.44 and most likely not related to this issue.
     
  3. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    97
    Likes Received:
    5
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    Thanks for the clarification.

    Now, here are my logs:

    Apr 4:
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout

    Apr 1:
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout
    WARNING: pgstat wait timeout


    The log messages is replicated on all past day in the other logs.
    Thanks for your time
     
  4. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    428
    Likes Received:
    29
    Trophy Points:
    103
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @urgido

    Could you open a ticket using the link in my signature so that we can take a closer look?
     
Loading...

Share This Page