How to configure "/usr/local/cpanel/scripts/update_db_cache" checks ?

vixon

Active Member
Sep 23, 2009
32
0
56
Estonia
cPanel Access Level
Root Administrator
Hello,

I'm running a postgresql server on VPS and cPanel keeps sending some alerts:

Cron /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Could anybody explain how to get rid of these messages ?
 
Last edited:

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Can you connect to postgresql?

Code:
su - postgres
psql
If you cannot, then postgres isn't properly running. Check if you have the rpms installed:

Code:
rpm -qa | grep -i postgres