I run PG and (when I had it) Oracle under supervise. I also run OACS under supervise. Search the forums as this has been discussed many times.

As Tom pointed out, it isn't a problem to run supervise from an init script. Although you certainly don't need to.