From: Ygor Degani <ygordegani@gmail.com>
To: pgsql-admin@postgresql.org
Subject: error vacuum full
Date: Mon, 5 Jan 2009 10:17:41 -0300
Message-ID: <4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ygordegani@gmail.com
Subject: Re: error vacuum full
In-Reply-To: <4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox