Thread: BUG #3555: does not work VACUUM

The following bug has been logged online:

Bug reference:      3555
Logged by:          Dmitry
Email address:      dd442@mail.ru
PostgreSQL version: 8.1
Operating system:   Linux Slackware 11
Description:        does not work VACUUM
Details:

root@darkstar:~# su postgres
postgres@darkstar:/root$ postgres -D /var/lib/pgsql/data/ -P taxi
WARNING:  database "baza" must be vacuumed within 976150 transactions
HINT:  To avoid a database shutdown, execute a full-database VACUUM in
"baza".
WARNING:  database "baza" must be vacuumed within 976150 transactions
HINT:  To avoid a database shutdown, execute a full-database VACUUM in
"baza".

PostgreSQL stand-alone backend 8.1.5


backend>VACUUM;


WARNING:  database "baza" must be vacuumed within 976005 transactions
HINT:  To avoid a database shutdown, execute a full-database VACUUM in
"baza".
WARNING:  database "baza" must be vacuumed within 976004 transactions
HINT:  To avoid a database shutdown, execute a full-
[...]
WARNING:  database "baza" must be vacuumed within 975895 transactions
HINT:  To avoid a database shutdown, execute a full-database VACUUM in
"baza".
backend>


is not got use VACUUM, VACUUM FULL...

3 months PostgreSQL work together with 1C:Enterprice 8.1 server.

Prompt, how correct givenned mistake.

Thank you, Dmitry.

Dmitry wrote:
> postgres@darkstar:/root$ postgres -D /var/lib/pgsql/data/ -P taxi
> ...
> backend>VACUUM;
>
>
> WARNING:  database "baza" must be vacuumed within 976005 transactions
> HINT:  To avoid a database shutdown, execute a full-database VACUUM in
> "baza".
> ...

The database that needs to be vacuumed is "baza", as the warning says.
You need to connect to "baza" database, not "taxi" as you did above, and
run VACUUM there.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

>>> On Sun, Aug 19, 2007 at 11:44 AM, in message
<200708191644.l7JGi6XF087983@wwwmaster.postgresql.org>, "Dmitry"
<dd442@mail.ru> wrote:=20
>=20
> HINT:  To avoid a database shutdown, execute a full-database VACUUM in
> "baza".
> . . .
> backend>VACUUM;
=20
Have you tried a VACUUM in database "baza"?
=20
-Kevin
=20