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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
