Hello: I'm on a project and asked me to install Apache Tomcat as server pages and PostgreSQL as database engine. So far so good and right install everything correctly. The application was done with AppFuse architecture originally utlizando MySQL, but issues like licensing and client wants to use PostgreSQL. And that is where I'm stuck, because Tomcat (or rather the Java VM) began comsumir large amount of memory (I get 1.5 GB of RAM) when using the application and there comes a time when it is hung and not answers, and this is the only application deployed on the server. Well, now the fatal question: Tomcat need any special configuration to use PostgreSQL? With MySQL the application works normally.
Team Summary (Virtualized with VMWare): S.O.: OpenSUSE 12.3 PostgreSQL 9.2 Apache Tomcat: 7.0.39 RAM: 4 GB Processor: 1 with two (2) cores. Any guide / link will help. Note: Sorry for the English, I am using a translator. Atte. -- Héctor Del Mestre