<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
OMG, forgot to `ALTER EXTENSION postgis update` one of the databases <span id="😕">
😕</span> Thank you!<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of rmrodriguez@carto.com <rmrodriguez@carto.com><br>
<b>Sent:</b> Tuesday, January 14, 2020 10:22<br>
<b>To:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [postgis-users] pg_upgrade from postgresql 11 postgis 3 to postgresql 12 postgis 3</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div>Hi,</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Tue, Jan 14, 2020 at 10:08 AM Michal Zimmermann <<a href="mailto:michal.zimmermann@gmtech.cz">michal.zimmermann@gmtech.cz</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div style="font-family:Arial,Helvetica,sans-serif; font-size:10pt; color:rgb(0,0,0)">
Hi,</div>
<div style="font-family:Arial,Helvetica,sans-serif; font-size:10pt; color:rgb(0,0,0)">
I'm having an issue upgrading from postgresql 11 postgis 3 to postgresql 12 postgis 3 via pg_upgrade utility. That's because pg_constraint.consrc was removed in postgresql 12 [1]. Is it possible to do such upgrade or do I need to run pg_dumpall and upgrade
semi-manually?</div>
</div>
</blockquote>
<div><br>
</div>
<div><br>
</div>
<div>Can you confirm the dump comes from 3.0? Both 2.5.2 and 3.0 changed `<span style="color:rgb(0,0,0); font-size:13.3333px">pg_constraint.consrc` with `</span>pg_get_constraintdef` so it shouldn't be complaining. You can check the version in the SQL scripts
with `Select postgis_full_version()`.</div>
<div> </div>
<div><br>
</div>
<div>Regards,</div>
</div>
-- <br>
<div dir="ltr" class="x_gmail_signature">Raúl MarÃn RodrÃguez<br>
<a href="http://carto.com" target="_blank">carto.com</a></div>
</div>
</div>
</body>
</html>