Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7B64562FA8A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  5 Jan 2009 11:19:47 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 92769-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  5 Jan 2009 11:19:44 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.236])
	by mail.postgresql.org (Postfix) with ESMTP id 99D0562F878
	for <pgsql-admin@postgresql.org>; Mon,  5 Jan 2009 11:19:44 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so8662737rvf.43
	for <pgsql-admin@postgresql.org>; Mon, 05 Jan 2009 07:19:42 -0800 (PST)
Received: by 10.140.162.21 with SMTP id k21mr10083503rve.206.1231161461097;
	Mon, 05 Jan 2009 05:17:41 -0800 (PST)
Received: by 10.141.175.7 with HTTP; Mon, 5 Jan 2009 05:17:41 -0800 (PST)
Message-ID: <4bb7c9f80901050517l3743891ax93ad672a07054b14@mail.gmail.com>
Date: Mon, 5 Jan 2009 10:17:41 -0300
From: "Ygor Degani" <ygordegani@gmail.com>
To: pgsql-admin@postgresql.org
Subject: error vacuum full
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_129735_27852485.1231161461089"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200901/13
X-Sequence-Number: 31060

------=_Part_129735_27852485.1231161461089
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_129735_27852485.1231161461089
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I use postgres-8.3.5. My database has 168 GB in size. Whenever i try to do vacuum full happens the following error:<br>&nbsp;<br clear="all">WARNING:&nbsp; terminating connection because of crash of another server process<br>DETAIL:&nbsp; 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.<br>
HINT:&nbsp; In a moment you should be able to reconnect to the database and repeat your command.<br>vacuumdb: vacuuming of database &quot;acotel_brazil_vas&quot; failed: server closed the connection unexpectedly<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This probably means the server terminated abnormally<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; before or while processing the request.<br><br>If i have autovacuum enabled, Do i need to do vacuum full?<br><br><br>Regards,<br>-- <br>Ygor Degani<br>

------=_Part_129735_27852485.1231161461089--