Re: [Fwd: [PATCHES] archiver ps display]

On Thu, 2007-12-13 at 15:58 +0100, Peter Eisentraut wrote:
> Am Donnerstag, 13. Dezember 2007 schrieb Simon Riggs:
> > Now that we have set archiver messages to DEBUG levels, there's no easy
> > way of seeing what file we are currently working on.
> 
> > After archive_command
> > postgres: archiver process   archived 00000001000000000000000B
> 
> ps isn't a very robust and portable way to monitor something so important.  
> Anything that is interesting should also be visible in some other, more 
> well-defined way, such as an SQL function or table.

Yeh, agreed, there are external ways of checking what's going on. 

I really meant for people to eyeball it. Since we do it for recovery, it
seems sensible to do the same thing for archiving.

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