Re: postgresql transaction id monitoring with nagios

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, May 02, 2006 at 12:06:30 -0700,
  Tony Wasson <ajwasson@xxxxxxxxx> wrote:
> 
> Ah thanks, it's a bug in my understanding of the thresholds.
> 
> "With the standard freezing policy, the age column will start at one
> billion for a freshly-vacuumed database."
> 
> So essentially, 1B is normal, 2B is the max. The logic is now..
> 
> The script detects a wrap at 2 billion. It starts warning once one or
> more databases show an age over 1.5 billion transactions. It reports
> critical at 1.75B transactions.
> 
> If anyone else understands differently, hit me with a clue bat.

Isn't this obsolete now anyway? I am pretty sure 8.1 has safeguards against
wrap around.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux