Re: [GENERAL] pg_standby observation

2008-03-27 Thread Simon Riggs
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

Re: [GENERAL] pg_standby observation

2007-09-16 Thread Simon Riggs
On Thu, 2007-09-13 at 15:13 -0500, Erik Jones wrote: 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

Re: [GENERAL] pg_standby observation

2007-09-16 Thread Simon Riggs
On Thu, 2007-09-13 at 11:38 -0700, Jeff Davis wrote: I think it would be useful if pg_standby (in version 8.3 contrib) could be observed in some way. Right now I use my own standby script, because every time it runs, it touches a file in a known location. That allows me to monitor that file,

Re: [GENERAL] pg_standby observation

2007-09-16 Thread Jeff Davis
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

Re: [GENERAL] pg_standby observation

2007-09-13 Thread Erik Jones
On Sep 13, 2007, at 1:38 PM, Jeff Davis wrote: I think it would be useful if pg_standby (in version 8.3 contrib) could be observed in some way. Right now I use my own standby script, because every time it runs, it touches a file in a known location. That allows me to monitor that file, and

Re: [GENERAL] pg_standby observation

2007-09-13 Thread Jeff Davis
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

Re: [GENERAL] pg_standby observation

2007-09-13 Thread Erik Jones
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