Scott,
If you had two applications that were each connecting to two different
databases, have you found that it's beneficial to have to different
instances of postgres running?
I have a few reasons why I think it would be better. One, it would be
beneficial to customize parameters for each application. They would be
different sizes for example and they may each have different amounts of
people connecting to them. Two, from a networking perspective, it may
be faster ( 2 different ports rather than one ) Do you agree with those
reasons or can you think of other reasons it would be wise? It seems
like it would be more administrative work to have 2 different instances,
so there may be some cons to that idea as well.
~DjK