Home > mailing lists

transactoin id wraparound problem - Mailing list pgsql-admin

From	Sriram Dandapani
Subject	transactoin id wraparound problem
Date	September 6, 2006 05:46:03
Msg-id	6992E470F12A444BB787B5C937B9D4DF05ABC7C8@ca-mail1.cis.local Whole thread Raw
Responses	Re: transactoin id wraparound problem Re: transactoin id wraparound problem
List	pgsql-admin

I get error messages on the console that says

WARNING: database "xxx" must be vacuumed within 10094646 transactions

I shutdown, restart pg and issue a vacuumdb –f <database>

I still get messages saying database must be vacuumed and the transaction count keeps decreasing. Is vacuumdb –f not working for some reason?

From: Miguel Arroz
Date: 05 September 2006, 23:14:44
Subject: How to check if VACUUM operations are working?

From: Niklas Johansson
Date: 06 September 2006, 10:38:53
Subject: Re: How to check if VACUUM operations are working?