s anwar wrote:
> I have a vacuum running for many days in postgres 8.1. Could the
> vacuum process be killed without causing any serious damage to the
> data. From the looks of the data directory, it seems to be rebuilding
> index files, but at a very slow speed.
>
Yes, it can be safely killed. kill -2 is your best bet. Anything
harder that a -2 will restart the backend (in recovery mode).
--
Brad Nicholson 416-673-4106 bnichols@ca.afilias.info
Database Administrator, Afilias Canada Corp.