<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hello Jeremiah,</div><div><br data-mce-bogus="1"></div><div>have you had chance to look at the upgrade process as described here: <a href="https://docs.evolveum.com/midpoint/guides/updating-to-pg16/">https://docs.evolveum.com/midpoint/guides/updating-to-pg16/</a> ?</div><div data-marker="__SIG_PRE__"><p>Best Regards,</p><p style="margin:0px"><span style="font-family:'arial' , 'helvetica' , sans-serif , 'font-size'"><strong>Katarina Bolemant</strong> | <span style="font-size:medium"><small>Development Team Leader</small></span></span></p><p style="margin:0px"><span style="font-family:'arial' , 'helvetica' , sans-serif"><a href="https://evolveum.com/" target="_blank" rel="nofollow noopener noreferrer"><img src="https://evolveum.com/wp-content/uploads/evolveum-email-signature-evolveum-logo.png" data-mce-src="https://evolveum.com/wp-content/uploads/evolveum-email-signature-evolveum-logo.png" width="299" height="73"></a><br></span> <a href="mailto:katkav@evolveum.com" style="font-size:13.3333px" target="_blank" rel="nofollow noopener noreferrer">katkav@evolveum.com</a> <span style="font-size:13.3333px"> | </span> <a href="http://www.evolveum.com/" style="font-size:13.3333px" target="_blank" rel="nofollow noopener noreferrer">www.evolveum.com</a><br><span style="font-size:medium"><small> </small></span></p><div><a href="https://tiime-unconference.eu/" target="_blank" rel="nofollow noopener noreferrer"><img src="https://evolveum.com/wp-content/uploads/evolveum-at-tiime-2024-email-signature.png" alt="Evolveum at TIIME 2024" width="396" height="90" border="0" data-mce-src="https://evolveum.com/wp-content/uploads/evolveum-at-tiime-2024-email-signature.png"></a></div><div style="line-height:40%"><br></div><div class="moz-signature"><a href="https://www.linkedin.com/company/evolveum" target="_blank" rel="nofollow noopener noreferrer"><img alt="Evolveum LinkedIn" src="https://evolveum.com/wp-content/uploads/2017/04/LinkedIn.png" width="23" height="23" border="0" data-mce-src="https://evolveum.com/wp-content/uploads/2017/04/LinkedIn.png"></a> <a href="https://twitter.com/evolveum" rel="noopener nofollow noopener noreferrer" target="_blank"><img alt="Evolveum Twitter" src="https://evolveum.com/wp-content/uploads/Twitter-new.png" data-mce-src="https://evolveum.com/wp-content/uploads/Twitter-new.png" width="23" height="23" border="0"></a> <a href="https://www.facebook.com/evolveum" rel="noopener nofollow noopener noreferrer" target="_blank"><img alt="Evolveum Facebook" src="https://evolveum.com/wp-content/uploads/Facebook.png" data-mce-src="https://evolveum.com/wp-content/uploads/Facebook.png" width="23" height="23" border="0"></a></div><p style="margin:0px"><span style="font-size:9pt">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.</span></p></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>To: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Cc: </b>"Haywood, Jeremiah" <jhaywo1@ilstu.edu><br><b>Sent: </b>Monday, December 11, 2023 6:06:48 PM<br><b>Subject: </b>[midPoint] Midpoint Repository Upgrade - Postgres<br></div><div><br><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></div><div data-marker="__QUOTED_TEXT__"><div class="WordSection1"><p class="MsoNormal">Hello all, </p><p class="MsoNormal"> </p><p class="MsoNormal">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.</p><p class="MsoNormal"> </p><p class="MsoNormal">Has anyone run into a similar issue and/or upgraded their Midpoint repository in place from an earlier Postgres version to 16?</p><p class="MsoNormal"> </p><p class="MsoNormal">Thank you,</p><p class="MsoNormal"> </p><p class="MsoNormal">Jeremiah Haywood</p><p class="MsoNormal">Lead IAM Administrator</p><p class="MsoNormal">Office of Technology Solutions | Illinois State University</p><p class="MsoNormal">Phone Number (309) 438-3829</p><p class="MsoNormal"> </p></div><br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>https://lists.evolveum.com/mailman/listinfo/midpoint<br></div></div></body></html>