I have upgraded from 6.2 to 6.5.1. I have a nightly script that runs a
vacuum analyze on my DB. This morning when I checked the output, it had
errored out.
I tried running it manually, and got the following result:
fnord% nohup /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
NOTICE: AbortTransaction and not in in-progress state
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.
Terminating.
I then tried running just the vacuum, which worked:
fnord% nohup /usr/local/pgsql/bin/psql -c "vacuum;" billing
VACUUM
fnord%
NOTE: After doing this, I rebooted the computer, and tried the two
commands again with the exact same results.I then tried them from directly
inside the psql tool, with the same results.
My questions:
What does that error message mean?
Should I worry about it (ie, does it have the posibility of corrupting
data)?
What is differnet with vacuum as opposed to vacuum analyze (I think the
analyze is for the indexes???)
Can I get away with running only a vacuum?
Thanks,
Jay Summet
************
