I've read the docs on the postgres maintenance and I'm disappointed that
the best Novell could do is point me to the PG website.

Does anyone with more PG experience have canned scripts that could be
used (barring the passwords/PG user) to do the Postgres vacuums /
maintenance on dedicated DS/Mobility systems?

Perhaps it would be good to post it to the DS wiki for others as well.