Thread: High CPU utilization: postgres, snort_inline, afcd
View Single Post
  #9 (permalink)  
Old 01-15-2009, 01:48 AM
Darin Marvin Darin Marvin is offline
Junior Member
  
Join Date: Dec 2007
Location: San Diego, CA
Posts: 8
Default system logs - killing postgres processes
Here is what the system log shows when I manually kill the postgres processes that are hogging the CPU:

2009:01:14-16:25:42 (none) postgres[6310]: [3-1] FATAL: terminating connection due to administrator command
2009:01:14-16:25:42 (none) postgres[6310]: [3-2] STATEMENT: select distinct flow_start_day from accounting where flow_start_day < $1
2009:01:14-16:25:45 (none) postgres[13409]: [3-1] FATAL: terminating connection due to administrator command
2009:01:14-16:25:45 (none) postgres[13409]: [3-2] STATEMENT: select distinct flow_start_day from accounting where flow_start_day < $1
2009:01:14-16:25:50 (none) postgres[20236]: [3-1] FATAL: terminating connection due to administrator command
2009:01:14-16:25:50 (none) postgres[20236]: [3-2] STATEMENT: select distinct flow_start_day from accounting where flow_start_day < $1
Reply With Quote