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