Re: monitoring postgres

I don't know, I'll check. Out of curiosity, can you send me an example
of the "standard startup packet"? Or at least tell me where in the code
I can see it?

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

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, January 29, 2003 11:49 AM
> To: Matthew Nuzum
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] monitoring postgres
>
> "Matthew Nuzum" <cobalt(at)bearfruit(dot)org> writes:
> > 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?
>
> I'd suggest sending a standard startup packet and looking for the
> "you're not authorized" response. Unfortunately, the startup packet
> isn't pure text ... can they cope with sending a string containing
> nulls?
>
> regards, tom lane