[midPoint] Midpoint Separate Audit Database Issues

[Haywood, Jeremiah]

Hello all,

 

At ISU we have been pursuing the implementation of auditing to a separate
database with Midpoint. We are running into some issues when upgrading from
4.4 to 4.4.1 where it seems that there are procedures referenced in
postgres-new-upgrade-audit.sql that only exist in the main database. Has
anyone come across similar issues?

 

Steps taken so far:

 

4.4:

*	postgres-new.sql on main db
*	postgres-new-quartz.sql on main db
*	postgres-new-audit.sql on audit db

 

4.4.1:

*	postgres-new-upgrade.sql on main db
*	postgres-new-upgrade-audit.sql on audit db

*	Ran into issues with procedure apply_change() not existing and
relation "m_org" does not exist

 

Thank you,

 

Jeremiah Haywood

Lead IAM Administrator

Office of Technology Solutions | Illinois State University

Phone Number (309) 438-3829

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220222/1475e657/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 7264 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220222/1475e657/attachment-0001.bin>