In previous releases of File Reporter, we supported deployments of the database and Engine on the same Windows Server host. However, subsequent performance testing, along with some notable technical support incidents, have demonstrated the potential for significant performance issues when utilizing a single host.
In addition, we previously shipped a package of PostgreSQL for Windows as well as the publicly available generic installer for PostgreSQL on Linux. This caused two specific issues:
PostgreSQL on Windows is generally the most performance limited of the supported database configurations, as opposed to PostgreSQL on Linux or SQL Server on Windows. For customers with performance concerns running PostgreSQL for Windows, we typically recommend moving to PostgreSQL on Linux as part of an initial performance tuning strategy.
The generic PostgreSQL installer for Linux is not distribution aware, causing issues with standard service scripts.
Beginning with the release of File Reporter 3.0, we are making the following changes:
We are strongly recommending that the database and Engine be hosted on separate servers.
We are strongly recommending the use of a Linux host when utilizing PostgreSQL as the database.
We are no longer including any PostgreSQL installation packages for Windows or Linux.
PostgreSQL may be installed using the Linux distribution’s built-in package channels, or by downloading an installer from http://www.postgresql.org/download/.