Обсуждение: 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