1.1 Database

1.1.1 PostgreSQL Database

If your deployment of Novell File Reporter will continue to use PostgreSQL, you should consider upgrading to the latest version in order to take advantage of any security updates and bug fixes. The Novell File Reporter ISO includes recent versions of both PostgreSQL 9.3.x and 9.4.x.

NOTE:The Novell File Reporter 2.6 ISO no longer includes installation packages for PostgreSQL 9.2.x. Although Novell File Reporter 2.6 continues to support PostgreSQL 9.2, we have only included the latest major releases of PostgreSQL 9.3 and 9.4.

For those wishing to update an existing PostgreSQL 9.2 installation, please download the corresponding Windows or Linux package from http://www.postgresql.org.

Note that the CC-PostgreSQL-9.x.y.exe installers for Windows that ship with the ISO are custom packages, and must be uninstalled or disabled prior to installation of any other provider’s PostgreSQL 9.x package for Windows.

IMPORTANT:For best performance, we strongly recommended that you install PostgreSQL on Linux rather than Windows. The included PostgreSQL installers for Windows are simply included as a convenience, but are not recommended for production implementations.

For users who want to update an existing PostgreSQL 9.3 installation, simply run the included CC-PostgreSQL-9.3.6.x.exe installer for Windows or the postgresql-9.3.x-linux-x64.run installer for Linux. Refer to the release notes at http://www.postgresql.org/docs/9.3/static/release-9-3-6.html.

For users who want to update an existing PostgreSQL 9.4 installation, simply run the included CC-PostgreSQL-9.4.1.x.exe installer for Windows or the postgresql-9.4.x-linux-x64.run installer for Linux. Refer to the release notes at http://www.postgresql.org/docs/9.4/static/release-9-4-1.html.

For users who want to upgrade from a previous release of PostgreSQL to a newer one (i.e. upgrade from PostgreSQL 9.3 or 9.2 to 9.4), refer to the upgrade documentation at http://www.postgresql.org/docs/current/static/pgupgrade.html.

1.1.2 Microsoft Database

If your plans for upgrading to Novell File Reporter 2.6 include switching from the PostgreSQL database to a Microsoft SQL Server database, there is currently no migration utility available for migrating the database content. You must, therefore, do one of the following:

  • Reinstall all Novell File Reporter components and, when running the Database Configuration Wizard, specify the Microsoft SQL Server database. You will then need to recreate all of the scan policies, scan targets, and so forth, that reside on the database.

  • Run the Database Configuration Wizard and specify the Microsoft SQL Server database. You will then need to recreate all of the scan policies, scan targets, and so forth, that reside on the database.