How to use multiple JasperReports Server instances with one Postgresql DB

How to use multiple JasperReports server instances with only one centralized Postgresql DB? Another words - let say I have Win server1, Win server2, Win server3 and Win server4.

On windows servers1,2 and 3 I need to install only JasperReport server (Tomcat) with no Postgresql DB, but on windows server 4 I want to install only Postgresql DB.

All Jasper server instances from servers 1,2 and 3 will connect to only one centralized Postgresql DB on win server4. Is it doable?

felded53's picture
Joined: Dec 1 2010 - 8:08am
Last seen: 1 year 12 months ago

1 Answer:

Yes - you can use the WAR file distribution on server 1 - 3 in order to skip the postgres install and point them to the repo DB on server 4.  This will require you to do the following:

  1. Manually install Postgres on server 4.
  2. Manually create the repostiory on your Postgres instance (see chapter 6 of the JasperReports-Server-Install-Guide)
  3. Manually install Tomcat on servers 1 - 3
  4. Use the WAR file distribution to install JRS (see chapter 5 of the JasperReports-Server-Install-Guide)

A word of caution- if you are using a load balancer in front of servers 1 - 3, you have to configure it for 'sticky session'.  Once a session is established, it needs to reamin on the server it started on.

mlaspina's picture
Joined: Nov 22 2013 - 1:38pm
Last seen: 8 years 3 months ago

Thank you. This is helpful.

felded53 - 9 years 4 months ago

Hi Guys,

Can i have full details on 4th point mentioned here."Use the WAR file distribution to install JRS".
How we can deploy war file is it directly from inividual 1-3 server's <js-install>/jaasper-pro.war file with out using <js-install>/buildomatica/

How we can configure same DB repository which on 4th server. Please briefly on this. where we have to configure same DB detials for all JSP instances...


gurram.balakrushna - 6 years 7 months ago