[midPoint] Midpoint Repository Upgrade - Postgres

[Katka Bolemant]

Hello Jeremiah, 

have you had chance to look at the upgrade process as described here: [ https://docs.evolveum.com/midpoint/guides/updating-to-pg16/ | https://docs.evolveum.com/midpoint/guides/updating-to-pg16/ ] ? 


Best Regards, 

Katarina Bolemant | Development Team Leader 

[ https://evolveum.com/ ] 
[ mailto:katkav at evolveum.com | katkav at evolveum.com ] | [ http://www.evolveum.com/ | www.evolveum.com ] 
[ https://tiime-unconference.eu/ ] 

[ https://www.linkedin.com/company/evolveum ] [ https://twitter.com/evolveum ] [ https://www.facebook.com/evolveum ] 


Disclaimer: The contents of this e-mail and attachment(s) thereto are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or Evolveum s.r.o. or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of Evolveum s.r.o. or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. 


From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Haywood, Jeremiah" <jhaywo1 at ilstu.edu> 
Sent: Monday, December 11, 2023 6:06:48 PM 
Subject: [midPoint] Midpoint Repository Upgrade - Postgres 



Hello all, 



We are looking to upgrade our midpoint instance from LTS version 4.4.* to 4.8. Our Postgres db is version 13.8 and as a part of the upgrade we're moving to the recommended version, 16. We're running into issues with generated columns. The error that we ran into is -- For binary upgrade, recreate inherited column . This seems to be due to additional restrictions on generated columns introduced in Postgres 16. 



Has anyone run into a similar issue and/or upgraded their Midpoint repository in place from an earlier Postgres version to 16? 



Thank you, 



Jeremiah Haywood 

Lead IAM Administrator 

Office of Technology Solutions | Illinois State University 

Phone Number (309) 438-3829 



_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20231211/7da6bb85/attachment.htm>