Vacuum analyze problem
| От | John Hatfield |
|---|---|
| Тема | Vacuum analyze problem |
| Дата | |
| Msg-id | 01C0A2FB.184C04A0.jhatfield@g-s.com.au обсуждение |
| Ответы |
Re: Vacuum analyze problem
|
| Список | 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
В списке pgsql-admin по дате отправления: