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


-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]


Reply via email to