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