Re: [monit] Postgres Port monitoring

[Mark Olliver]

Do i have an option to extend the test to give it a username and
password as i no longer get the incomplete startup packet message in the
log instead now i get FATAL: database "root" does not exist.

Regards

Mark


On Tue, 2010-04-13 at 13:28 +0200, address@hidden wrote:
> Hello,
> 
> you can use postgresql protocol test ... just extend the test statement using 
> 'protocol pgsql':
> 
>   if failed port 5432 protocol pgsql then alert
> 
> Regards,
> M/Monit support
> 
> 
> On Tue, Apr 13, 2010 at 09:13:13AM +0100, Mark Olliver wrote:
> > Hi,
> > 
> > I am using monit to monitor the postgres service is up, currently it
> > does this via a standard connect to the 5432 port. However this is
> > causing an issue in the postgres server log as monit connects to the
> > port but sends no data to postgres so postgres logs and incomplete
> > startup error.
> > To overcome this i think monit needs to actually connect to the database
> > as a user and then exit, (which would probably be a more valid test). Is
> > there a way to do this or and suggested enhancement?
> > 
> > Regards
> > 
> > Mark
> > 
> > Mark Olliver BSc (Hons) MBCS CITP
> > Thermeon (System Admin)
> > Russ Hill Farm, Russ Hill, Charlwood, RH6 0EL, UK
> > +44 1293 864 300
> > 
> > 
> > 
> > --
> > To unsubscribe:
> > http://lists.nongnu.org/mailman/listinfo/monit-general


Mark Olliver BSc (Hons) MBCS CITP
Thermeon (System Admin)
Russ Hill Farm, Russ Hill, Charlwood, RH6 0EL, UK
+44 1293 864 300