error vacuum full

From: "Ygor Degani" <ygordegani(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: error vacuum full
Date: 2009-01-05 13:17:41
Message-ID: 4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I use postgres-8.3.5. My database has 168 GB in size. Whenever i try to do
vacuum full happens the following error:

WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
vacuumdb: vacuuming of database "acotel_brazil_vas" failed: server closed
the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

If i have autovacuum enabled, Do i need to do vacuum full?

Regards,
--
Ygor Degani

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2009-01-05 15:40:45 Re: error vacuum full
Previous Message Scott Marlowe 2009-01-05 05:32:05 Re: data convert