Postgres Pro
Downloads
Home   >   mailing lists

WARNING: database must be vacuumed within 8439472 transactions - Mailing list pgsql-admin

From Prabhjot Sheena
Subject WARNING: database must be vacuumed within 8439472 transactions
Date
Msg-id CAOf_bQZdiQFrQtvyh5SCzQc63GZWYt=D=oOu4f2mgBKVAO9tEA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions  (Mike Christensen <mike@kitchenpc.com>)
Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: WARNING: database must be vacuumed within 8439472 transactions  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-admin
Tree view
Hello
       We are using postgresql 8.3 database for last 5 yrs for this production database and its running fine. This is our critical database which runs 24*7. This weekend we started getting these messages

HINT:  To avoid a database shutdown, execute a full-database VACUUM.
WARNING:  database  must be vacuumed within 8439472 transactions

i am currently running this command

vacuumdb --analyze db

while this command is running i m still getting these messages

WARNING:  database  must be vacuumed within 2645303 transactions.

The value of number of transactions is going down every minute

Can anyone tell me what is the best way to sort up this issue.

Thanks
Avi



pgsql-admin by date:

Previous
From: Szymon Guz
Date:
Subject: Re: cannot remove schema public
Next
From: Mike Christensen
Date:
Subject: Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions