John Hatfield <jhatfield@g-s.com.au> writes:
> My problem is when running the vacuum with analyze an error occurs but
> it runs ok without the analyse.
Try "vacuum verbose analyze" so you can see which table it's failing on
(or, just look in the postmaster log to see which table is mentioned
last). There's probably a core file left from the crashed backend;
can you get a stack backtrace from it with gdb?
regards, tom lane