Native PostgreSQL Upgrade Script: postgres-audit-upgrade.sql

Last modified 01 Jul 2026 12:22 UTC

This page documents schema changes applied to existing databases by config/sql/native/postgres-audit-upgrade.sql.

Version summary

MidPoint version Changes range

midPoint 4.11

11-12

midPoint 4.10

10

midPoint 4.9

9

midPoint 4.8

4-8

midPoint 4.7

3

midPoint 4.5

2

midPoint 4.4.1

1

postgres-audit-upgrade.sql - midPoint 4.11

Changes

Change Description

Change 12

Adds CONNECTOR_DEVELOPMENT object type value.

Change 11

Adds application object type value.

postgres-audit-upgrade.sql - midPoint 4.10

Changes

Change Description

Change 10

Adds schema object type value.

postgres-audit-upgrade.sql - midPoint 4.9

Changes

Change Description

Change 9

Adds policy object type value.

postgres-audit-upgrade.sql - midPoint 4.8

Changes

Change Description

Change 8

Adds information disclosure audit event type value.

Change 7

Adds role analysis cluster and role analysis session object type values.

Change 6

Adds shadow kind and intent audit delta columns.

Change 5

Adds effective-principal audit columns and privilege modification type.

Change 4

Adds RESOURCE audit stage and DISCOVER_OBJECT audit event type value.

postgres-audit-upgrade.sql - midPoint 4.7

Changes

Change Description

Change 3

Adds SIMULATION_RESULT and MARK object type values used by audit records.

postgres-audit-upgrade.sql - midPoint 4.5

Changes

Change Description

Change 2

Adds MESSAGE_TEMPLATE to audit object type values.

postgres-audit-upgrade.sql - midPoint 4.4.1

Changes

Change Description

Change 1

Updates the audit monthly partition creation procedure to support creating partitions in the past using a negative argument.

Was this page helpful?
YES NO
Thanks for your feedback