2014-10-15 23:12 GMT+02:00 Josh Berkus <j...@agliodbs.com>: > On 10/15/2014 01:25 PM, Guillaume Lelarge wrote: > > Monitoring is another matter, and I don't really think a monitoring > > solution should count the WAL files. What actually really matters is the > > database availability, and that is covered with having enough disk space > in > > the WALs partition. > > If we don't count the WAL files, though, that eliminates the best way to > detecting when archiving is failing. > > WAL files don't give you this directly. You may think it's an issue to get a lot of WAL files, but it can just be a spike of changes. Counting .ready files makes more sense when you're trying to see if wal archiving is failing. And now, using pg_stat_archiver is the way to go (thanks Gabriele :) ).
-- Guillaume. http://blog.guillaume.lelarge.info http://www.dalibo.com
