PostgreSQL

Supported Versions

File Reporter24.1 supports the following versions of PostgreSQL:

• PostgreSQL 16
• PostgreSQL 15
• PostgreSQL 14

Minimum Requirements

• Any major 64-bit Linux distribution supported by PostgreSQL.

  PostgreSQL itself is supported on many host systems including UNIX, Linux, and Windows variants. However, support in troubleshooting PostgreSQL itself is limited to the following major Linux distributions:

  • Red Hat Enterprise Linux (RHEL)

  • SUSE Linux Enterprise Server (SLES)

  • Ubuntu

  For PostgreSQL installations on other hosts, support is limited to the data and schema in the database itself, not performance tuning or configuration.

  Due to performance limitations, installing PostgreSQL on Windows is discouraged, especially for large deployments.

• Minimum of 16 GB of RAM

  Depending on the size and frequency of your scans, this amount might need to be significantly increased.

• Minimum of 100 GB of disk space

  Depending on the size and frequency of your scans, this amount might need to be significantly increased.

Installing and Configuring a PostgreSQL Database

For procedures on installing and configuring PostgreSQL, see the following:

• https://www.postgresql.org/docs/current/static/creating-cluster.html

• https://www.postgresql.org/docs/current/static/runtime.html

• https://www.postgresql.org/docs/current/static/runtime-config.html

You will need to follow the references that are specific to the version of PostgreSQL that is installed in your environment.

Adding Required Extensions

File Reporter requires the pgcrypto PostgreSQL extension.

If the extension has not been installed you will see an error similar to the following when running the File Reporter database configuration utility:

Error: 0A000: extension "pgcrypto" is not available Detail: could not open extension control file "/usr/share/postgresql15/extension/pgcrypto.control": No such file or directory