Vacuum analyze problem

From: John Hatfield <jhatfield(at)g-s(dot)com(dot)au>
To: "'PostgreSQL Admin'" <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum analyze problem
Date: 2001-03-01 23:28:07
Message-ID: 01C0A2FB.184C04A0.jhatfield@g-s.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

My problem is when running the vacuum with analyze an error occurs but it runs ok without the analyse.

From psql
gsmain_test=# vacuum;
VACUUM
gsmain_test=# vacuum analyze;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

From the shell
bash-2.04$ vacuumdb -d gsmain_test
VACUUM
bash-2.04$ vacuumdb -d gsmain_test -z
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost
vacuumdb: vacuum failed
bash-2.04$

Linux Box
Postgresql 7.0.3-2 installed from rpms
Redhat 7.0

Any help is greatly appreciated

Regards,

John

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-03-02 01:49:49 Re: Vacuum analyze problem
Previous Message Fredrik Larsson 2001-03-01 22:57:31 Couldn't find any tables, sequences or indices!