BUG #4874: vacuum doest work
The following bug has been logged online:
Bug reference: 4874
Logged by: Roman Galeev
Email address: ip@ncom-ufa.ru
PostgreSQL version: 8.1
Operating system: Debian Sarge
Description: vacuum doest work
Details:
I've constantly got messages like this:
2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
within 10532638 transactions
2009-06-23 20:43:42 YEKST ПОДСКАЗКА: To avoid a database shutdown,
execute a full-database VACUUM in "testing".
but issuing vacuum does not help.
I've issued vacuum, vacuum full, vacuum freeze several times.
The only change I see is decreasing number of transactions.
"Roman Galeev" <ip@ncom-ufa.ru> writes:
I've constantly got messages like this:
2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
within 10532638 transactions
2009-06-23 20:43:42 YEKST ПОДСКАЗКА: To avoid a database shutdown,
execute a full-database VACUUM in "testing".
but issuing vacuum does not help.
You need to issue it as a superuser.
regards, tom lane
На Tue, 23 Jun 2009 11:13:21 -0400
Tom Lane <tgl@sss.pgh.pa.us> записано:
2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
within 10532638 transactions
2009-06-23 20:43:42 YEKST ааааЁааааа: To avoid a database shutdown,
execute a full-database VACUUM in "testing".but issuing vacuum does not help.
You need to issue it as a superuser.
It helped, thank's a lot.
--
With best regards,
Roman Galeev