pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postmaster errors
5+ messages / 2 participants
[nested] [flat]

* Postmaster errors
@ 2006-02-02 15:58 mcelroy, tim <tim.mcelroy@bostonstock.com>
  2006-02-02 16:10 ` Re: Postmaster errors Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 5+ messages in thread

From: mcelroy, tim @ 2006-02-02 15:58 UTC (permalink / raw)
  To: pgsql-admin

Good morning,

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

Thank you,
Tim

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postmaster errors
  2006-02-02 15:58 Postmaster errors mcelroy, tim <tim.mcelroy@bostonstock.com>
@ 2006-02-02 16:10 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 5+ messages in thread

From: Michael Fuhr @ 2006-02-02 16:10 UTC (permalink / raw)
  To: mcelroy, tim <tim.mcelroy@bostonstock.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postmaster errors
@ 2006-02-02 17:34 mcelroy, tim <tim.mcelroy@bostonstock.com>
  2006-02-02 18:04 ` Re: Postmaster errors Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 5+ messages in thread

From: mcelroy, tim @ 2006-02-02 17:34 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postmaster errors
  2006-02-02 17:34 Re: Postmaster errors mcelroy, tim <tim.mcelroy@bostonstock.com>
@ 2006-02-02 18:04 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 5+ messages in thread

From: Michael Fuhr @ 2006-02-02 18:04 UTC (permalink / raw)
  To: mcelroy, tim <tim.mcelroy@bostonstock.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postmaster errors
@ 2006-02-02 18:06 mcelroy, tim <tim.mcelroy@bostonstock.com>
  0 siblings, 0 replies; 5+ messages in thread

From: mcelroy, tim @ 2006-02-02 18:06 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin

Great, thank you for the additional info.

Tim

 -----Original Message-----
From: 	Michael Fuhr [mailto:mike@fuhr.org] 
Sent:	Thursday, February 02, 2006 1:05 PM
To:	mcelroy, tim
Cc:	'pgsql-admin@postgresql.org'
Subject:	Re: [ADMIN] Postmaster errors

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-02-02 18:06 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-02 15:58 Postmaster errors mcelroy, tim <tim.mcelroy@bostonstock.com>
2006-02-02 16:10 ` Michael Fuhr <mike@fuhr.org>
2006-02-02 17:34 Re: Postmaster errors mcelroy, tim <tim.mcelroy@bostonstock.com>
2006-02-02 18:04 ` Michael Fuhr <mike@fuhr.org>
2006-02-02 18:06 Re: Postmaster errors mcelroy, tim <tim.mcelroy@bostonstock.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox