Add enhanced support for external database services (inc separate main Praefect)

What does this MR do?

MR adds in enhanced support for a separate Praefect Postgres service (external) if desired.

Also ensures database and user are created on external service for main database.