On Sep 13, 2007, at 3:02 PM, Jeff Davis wrote:
> On Thu, 2007-09-13 at 14:05 -0500, Erik Jones wrote:
>> If you include the -d option pg_standby will emit logging info on
>> stderr so you can tack on something like 2>> logpath/standby.log.
>> What it is lacking, however, is timestamps in the output when it
>> successfully recovers a WAL file. Was there something more ou were
>> looking for?
>
> I don't think the timestamps will be a problem, I can always pipe it
> through something else.
>
> I think this will work, but it would be nice to have something
> that's a
> little more well-defined and standardized to determine whether some
> kind
> of error happens during replay.
Right. The problem there is that there really isn't anything
standardized about pg_standby, yet. Or, if it is, it hasn't been
documented, yet. Perhaps you could ask Simon about the possible
outputs on error conditions so that you'll have a definite list to
work with?
> Ultimately, what I'm trying to do is make it so that pgsnmpd can
> monitor
> this, and trap if a problem occurs. In order for pgsnmpd to do this
> in a
> way that works for a large number of people, it can't make too many
> assumptions about logging options, etc.
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com