Top
Enterprise Postgres 16 SP1 Release Notes

2.13.1 Changes due to Changes in the pg_dump Specification

Incompatibility

If you are using multiple non-superuser sensitivity confidentiality management role to manage the sensitivity matrix, run the product-provided policy configuration script to define a row-level security feature policy on the table provided by the sensitivity support feature to make the sensitivity management roles independent of each other.

In Fujitsu Enterprise Postgres 15 SP2 or earlier, the effects of this script could be retained and backed up by pg_dump, but as of Fujitsu Enterprise Postgres 16, policy settings can no longer be backed up.

Action method

In Fujitsu Enterprise Postgres 16 or later, if you are managing a sensitivity matrix using more than one confidentiality management role other than superuser, then immediately after restoring a clear-text dump file using pg_dump, run the following command as superuser to reapply the confidentiality management feature policy:

psql -f ${install_dir}/share/extension/pgx_confidential_management_support_policy.sql