<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
Hello all,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
I move db servers to newer servers but I misinstalled the new version of postgis, former posgis version was 3.0.0 but in new servers I realize I installed 3.3.2, therefore I get some errors <span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted4"><span class="ContentPasted4"> </span>deprecated<span class="ContentPasted4"> func</span></span>
like </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0">
ERROR,0A000,"A stored procedure tried to use deprecated C function 'pgis_geometry_union_finalfn'","Library function 'pgis_geometry_union_finalfn' was deprecated in PostGIS 3.3.2","Consider running: SELECT postgis_extensions_upgrade()"<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
Now what do you recommend me to do, should I remove postgis33_12-3.3.2-1.rhel8.x86_64 package and install postgis30_12.x86_64</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
or just run "<span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted3">SELECT postgis_extensions_upgrade()" and find alternate function to deprecated ones?</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
This is the prod server.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
<span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted3"><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
<span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted3">best regards.</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof ContentPasted0 ContentPasted1 ContentPasted2">
<span style="background-color:rgb(255, 255, 255);display:inline !important" class="ContentPasted3">thanks.</span></div>
</body>
</html>