vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| That was it, a fellow admin is watching the postmaster with OpenNMS.... Thanks for the tip! Tim -----Original Message----- From: Michael Fuhr [mailto:mike@fuhr.org] Sent: Thursday, February 02, 2006 11:10 AM To: mcelroy, tim Cc: 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] Postmaster errors On Thu, Feb 02, 2006 at 10:58:52AM -0500, mcelroy, tim wrote: > Has anyone encountered these errors? They repeat every five (5) minutes in > my log file. Is there something I may have set incorrectly in my > postgresql.conf file? Odd as I find them in my DEV & QA logs but not > Production.... > > 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOG: 08P01: > incomplete startup packet > 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOCATION: > ProcessStartupPacket, postmaster.c:1311 Something connected to your server without carrying out a proper PostgreSQL conversation. One of the usual suspects is a probe that connects to the port and then immediately disconnects, like a port scan or a network management system. Since it's happening every five minutes I'd guess the latter. -- Michael Fuhr |
| ||||
| On Thu, Feb 02, 2006 at 12:34:44PM -0500, mcelroy, tim wrote: > That was it, a fellow admin is watching the postmaster with OpenNMS.... I think OpenNMS has a way to set up a custom poller that can do anything you want (e.g., connect to the database, issue a query, check the results). I was playing with that a year or two ago; at that time the OpenNMS documentation was pretty scant but I remember coming across the feature in the release notes or some other document. Monitoring the database with such a poller would tell you more about whether the service is available than a simple TCP connect does. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |