Re: fatal error on 8.1 server

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