monitoring postgres

From: "Matthew Nuzum" <cobalt(at)bearfruit(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: monitoring postgres
Date: 2003-01-29 16:15:46
Message-ID: 006e01c2c7b1$ae827800$6700a8c0@mattspc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I subscribe to a server monitoring service that notifies me if any of my
public servers stop responding to periodic queries.

It has predefined functions for monitoring standard web facing services
such as ftp, telnet, http, https etc. They also offer a custom function
for other services, which is what I need to use to monitor my postgres
servers.

They do a challenge and response type query where they send a specific
message on UDP or TCP port of my choosing and if they don't get the
response that I specify then they send me a page.

The problem is that I block traffic to my Postgres servers at the
Postgres level using a list of acceptable hosts that can connect to the
server. I don't want to add their hosts to my server's allow list.

I'm not blocking them at the firewall, so they can see the server on
that port, but can anyone suggest a text string and expected response
that I can use to know that the server is OK?

--
Matthew Nuzum
www.bearfruit.org
cobalt(at)bearfruit(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rogier van Eeten 2003-01-29 16:16:48 Re: Website troubles
Previous Message Stephan Szabo 2003-01-29 16:12:33 Re: URGENT: referential integrity problem