Re: fatal error on 8.1 server

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Tony Caduto wrote:
> 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 :-(

Strange -- autovacuum should have started an automatic database-wide
vacuum on that database, even if disabled.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support