PostgreSQL Versions Supported by Black Duck SCA

Black Duck SCA continuously updates its support for PostgreSQL versions to enhance the performance and reliability of its services. This document summarizes supported versions for both internal PostgreSQL containers and external PostgreSQL instances, along with migration guidance.

Supported PostgreSQL Versions

Internal PostgreSQL Container:

  • As of Black Duck SCA 2024.10.0, PostgreSQL 15 is the supported version for the internal PostgreSQL container.

  • Starting with Black Duck SCA 2023.10.0, PostgreSQL settings are automatically configured for deployments using the internal PostgreSQL container.

External PostgreSQL Instances:

  • For new external PostgreSQL installations, Black Duck recommends using the latest stable version, PostgreSQL 17.
  • Preliminary testing support for PostgreSQL 18 was introduced in Black Duck SCA 2026.4.0. This support is for testing environments only and not for production use.

Important Notes

  • PostgreSQL Sizing: Refer to the Black Duck SCA Hardware Scaling Guidelines for sizing recommendations.
  • Antivirus Caution: Avoid running antivirus scans on the PostgreSQL data directory. Antivirus software may lock files and interfere with database operations, potentially causing errors such as "too many open files in the system."

Migration Process for PostgreSQL 9.6 to Newer Versions

This section applies to upgrades from PostgreSQL 9.6-based Black Duck SCA versions (releases prior to 2022.2.0) to version 2022.10.0 or later:

  • Migration is handled by the blackduck-postgres-upgrader container.
  • Key migration steps include:
    • Rearrangement of PostgreSQL data volume folder layout to simplify future upgrades.
    • Change of the UID owner of the data volume to the new default UID (1001), with deployment-specific instructions available.
    • Execution of the pg_upgrade script to migrate the database to PostgreSQL 13.
    • Running a plain ANALYZE on the PostgreSQL 13 database to initialize query planner statistics.
  • After these steps, the blackduck-postgres-upgrader container exits.