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

Reply via email to