Re: pg_standby observation

On Sun, 2007-09-16 at 11:18 -0700, Jeff Davis wrote:
> On Sun, 2007-09-16 at 09:25 +0100, Simon Riggs wrote:
> > Well, the definition of it working correctly is that a "restored log
> > file..." message occurs. Even with archive_timeout set there could be
> > various delays before that happens. We have two servers and a network
> > involved, so the time might spike occasionally.
> >
>
> The problem is, a "restored log file message" might appear in a
> different language or with a different prefix, depending on the
> settings. That makes it hard to come up with a general solution, so
> everyone has to use their own scripts that work with their logging
> configuration.
>
> In my particular case, I want to know if those logs aren't being
> replayed, regardless of whether it's a network problem or a postgres
> problem.

Currently pg_standby just sits there waiting. If you can specify the
events you wish to monitor and what action to take when that event
happens, I can make it do this.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk