What do you mean by "system"? It's certainly possible to have two instances of Tomcat running on the same machine (or one Tomcat instance serving multiple web apps under multiple domains and/or URLs), all the while accessing multiple DBs running on the same DB server. Maybe you can provide some more detail about what you're trying to accomplish.
Joined: Nov 09, 2011
Thank you for your response.
By system I mean web based applications.Two web application system-one tomcat server and one db server.so the issue here how to create the db1 for web app 1,db2 for web app2.
You can put as many Tomcat instances on a physical or virtual machine as you have memory to cram them into, although once you have more Tomcats than CPU cores, they won't make optimum use of the hardware.
You can also put multiple postgresql instances on a physical machine, but that's pretty rare. It's far more common to have one instance and multiple databases or schemas within that instance. In fact, it's very common to have only one (or a few) postgresql servers for an entire shop and have all the apps use the central servers, regardless of what machine the application itself resides on.
Customer surveys are for companies who didn't pay proper attention to begin with.