PostgreSQL

Supported Versions

File Reporter25.4 supports the following versions of PostgreSQL:

• PostgreSQL 18
• PostgreSQL 17
• PostgreSQL 16

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

Review the following links for the procedures to install and configure PostgreSQL:

• 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

Follow the references that are specific to the version of PostgreSQL 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