There is no simple answer to your question/situation - it depends on too many different factors. In general, as a pain relief methodology, it is relatively safe and effective.
Yes, the pain medication pump is usually effective in terminal patients. It pumps opiates, local anesthetics, or muscle relaxers into the area around the patient's spine to control pain.