pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostmaster errors
5+ messages / 2 participants
[nested] [flat]
* Postmaster errors
@ 2006-02-02 15:58 mcelroy, tim <tim.mcelroy@bostonstock.com>
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 16:10 Michael Fuhr <mike@fuhr.org>
parent: mcelroy, tim <tim.mcelroy@bostonstock.com>
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>
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 18:04 Michael Fuhr <mike@fuhr.org>
parent: mcelroy, tim <tim.mcelroy@bostonstock.com>
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