Re: fatal error on 8.1 server

[Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>]

Martijn van Oosterhout wrote:
> On Mon, Nov 27, 2006 at 02:22:19PM -0600, Tony Caduto wrote:
>   
> > Just in case anyone is interested I did get it up and running with no 
> > damage to the system.
> > It took well over a year for it to reach the 1 million threshold mark.  
> >     
>
> You mean one *billion*, right?
>
> That's one busy server!
>
> Hopeefully you've updated your maintainence setup to avoid this in the
> future?
>
> Have a nice day,
>   
The server stops accepting requests when it is 1 million transactions 
away from hitting 1 billion.
That's what I meant by the 1 million threshold :-)

I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f 
-q  each night but this one slipped through the cracks :-(

Later,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration