Bug#296100: [Pkg-nagios-devel] Bug#296100: nagios-pgsql: postgres process eats 6% CPU

Marcus Better Marcus Better <marcus@better.se>, 296100@bugs.debian.org
Mon, 21 Feb 2005 17:33:04 +0100


> who's the owner for the database?  have you tried changing it?

The owner was 'postgres'. I created the database according to the 
instructions in README.pgsql.

I have now recreated the database with nagios as owner instead. This 
seems to fix the problem!

"ps" now shows a different command line:
------------------------------------
12637 ?        S      0:00 postgres: nagios nagios 127.0.0.1 idle
------------------------------------

This suggests that the process used to hang or fail on the DELETE 
command before, perhaps due to incorrect permissions. (They were set 
according to README.pgsql.)

Marcus