Monitoring postmaster.log

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Monitoring postmaster.log

Walker, Jed S
Monitoring postmaster.log

I am trying to setup rules to monitor the postmaster.log file, but I don't see a way to do it cleanly. I want to monitor for FATAL  and PANIC, but the problem is that when someon give the wrong password logging in, it gives a FATAL error and I don’t want to be woken up in the middle of the night because of a typo.

I don't see a parameter where you can disable the error level logged to the postmaster log file for only session related events. Am I missing something?

Thanks,

Jed.

Reply | Threaded
Open this post in threaded view
|

Re: Monitoring postmaster.log

Tom Lane-2
"Walker, Jed S" <[hidden email]> writes:
> I am trying to setup rules to monitor the postmaster.log file, but I
> don't see a way to do it cleanly. I want to monitor for FATAL  and
> PANIC, but the problem is that when someon give the wrong password
> logging in, it gives a FATAL error and I don't want to be woken up in
> the middle of the night because of a typo.

Do you actually have a use-case for watching for FATAL errors?  I don't
offhand know of any examples where that's important for an admin to pay
attention to.  FATAL implies a clean exit of the current session, and
we don't really use that for anything except connection startup rejections
of various sorts (like bad password or too many clients already).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match