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?
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:
- Manually install Postgres on server 4.
- Manually create the repostiory on your Postgres instance (see chapter 6 of the JasperReports-Server-Install-Guide)
- Manually install Tomcat on servers 1 - 3
- 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.