NR-180723: update integration tests to support postgres-16

[sigilioso]

Context

The json-schema based test have been updated since they were failing if we updated them to the latest supported version. Summary of changes. This was due to the lack of flexibility in json-schema based tests and changes in the latests Postgres versions.

The latest tested version was Postgres 13, find bellow a summary of changes affecting the integration tests is included below.

Inventory related changes from Postgres 13

• Postgres 14:
  • vacuum_cleanup_index_scale_factor server setting was removed.
  • operator_precedence_warning server settings was removed
• Postgres 15:
  • stats_temp_directory server setting was removed
• Postgres 16:
  • force_parallel_mode was renamed to debug_parallel_mode
  • lc_collate and lc_type read only server variables were removed
  • promote_trigger_file server variable was removed

Metrics related changes from Postgres 13

• The number of entities (internal tables and indexes) varies depending on the version, therefore json-schemas might not match for different versions.