<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><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;}
@font-face
{font-family:Menlo;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.gmail-apple-converted-space
{mso-style-name:gmail-apple-converted-space;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.k
{mso-style-name:k;}
span.w
{mso-style-name:w;}
span.n
{mso-style-name:n;}
span.nf
{mso-style-name:nf;}
span.p
{mso-style-name:p;}
span.mi
{mso-style-name:mi;}
span.no
{mso-style-name:no;}
span.s1
{mso-style-name:s1;}
span.kt
{mso-style-name:kt;}
span.o
{mso-style-name:o;}
span.s2
{mso-style-name:s2;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>It looks like you are running a 2.4 before the view upgrade fix was applied. If you can’t upgrade your old cluster to the latest 2.4 micro, you can apply the attached create view definitions and that should fix your issue. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>The issue is that I think in PG 12, pg_constraint.consrc was taken out so we had to rework the views to use pg_get_constraintdef function instead.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Since pg_upgrade tries to run the old view definition, it fails.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hope that helps,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Nikhil Shetty<br><b>Sent:</b> Thursday, August 18, 2022 11:50 AM<br><b>To:</b> PostGIS Development Discussion <postgis-devel@lists.osgeo.org><br><b>Subject:</b> [postgis-devel] PostGIS upgrade error<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi Team,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>We are upgrading PostgreSQL (11.7 to 13.6) and PostGIS (2.4.4 to 3.2.1) but we are getting below error during pg_upgrade.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>pg_restore: while PROCESSING TOC:<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>pg_restore: from TOC entry 309; 1259 17730 VIEW geometry_columns postgres<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>pg_restore: error: could not execute query: ERROR:<span class=gmail-apple-converted-space> </span>column s.consrc does not exist<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>LINE 28: <span class=gmail-apple-converted-space> </span>"replace"("split_part"("s"."consrc", ''''::"text...<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>^<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>HINT:<span class=gmail-apple-converted-space> </span>Perhaps you meant to reference the column "s.conkey" or the column "s.conbin".<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>Command was:<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-- For binary upgrade, must preserve pg_type oid<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>SELECT pg_catalog.binary_upgrade_set_next_pg_type_oid('17732'::pg_catalog.oid);<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-- For binary upgrade, must preserve pg_type array oid<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>SELECT pg_catalog.binary_upgrade_set_next_array_pg_type_oid('17731'::pg_catalog.oid);<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-- For binary upgrade, must preserve pg_class oids<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>SELECT pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('17730'::pg_catalog.oid);<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>CREATE VIEW "public"."geometry_columns" AS<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>SELECT ("current_database"())::character varying(256) AS "f_table_catalog",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"n"."nspname" AS "f_table_schema",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"c"."relname" AS "f_table_name",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"a"."attname" AS "f_geometry_column",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>COALESCE("public"."postgis_typmod_dims"("a"."atttypmod"), "sn"."ndims", 2) AS "coord_dimension",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>COALESCE(NULLIF("public"."postgis_typmod_srid"("a"."atttypmod"), 0), "sr"."srid", 0) AS "srid",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>("replace"("replace"(COALESCE(NULLIF("upper"("public"."postgis_typmod_type"("a"."atttypmod")), 'GEOMETRY'::"text"), "st"."type", 'GEOMETRY'::"text"), 'ZM'::"text", ''::"text"), 'Z'::"text", ''::"text"))::character varying(30) AS "type"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>FROM (((((("pg_class" "c"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>JOIN "pg_attribute" "a" ON ((("a"."attrelid" = "c"."oid") AND (NOT "a"."attisdropped"))))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>JOIN "pg_namespace" "n" ON (("c"."relnamespace" = "n"."oid")))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>JOIN "pg_type" "t" ON (("a"."atttypid" = "t"."oid")))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>LEFT JOIN ( SELECT "s"."connamespace",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conrelid",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conkey",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"replace"("split_part"("s"."consrc", ''''::"text", 2), ')'::"text", ''::"text") AS "type"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>FROM "pg_constraint" "s"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>WHERE ("s"."consrc" ~~* '%geometrytype(% = %'::"text")) "st" ON ((("st"."connamespace" = "n"."oid") AND ("st"."conrelid" = "c"."oid") AND ("a"."attnum" = ANY ("st"."conkey")))))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>LEFT JOIN ( SELECT "s"."connamespace",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conrelid",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conkey",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>("replace"("split_part"("s"."consrc", ' = '::"text", 2), ')'::"text", ''::"text"))::integer AS "ndims"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>FROM "pg_constraint" "s"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>WHERE ("s"."consrc" ~~* '%ndims(% = %'::"text")) "sn" ON ((("sn"."connamespace" = "n"."oid") AND ("sn"."conrelid" = "c"."oid") AND ("a"."attnum" = ANY ("sn"."conkey")))))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>LEFT JOIN ( SELECT "s"."connamespace",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conrelid",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>"s"."conkey",<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>("replace"("replace"("split_part"("s"."consrc", ' = '::"text", 2), ')'::"text", ''::"text"), '('::"text", ''::"text"))::integer AS "srid"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>FROM "pg_constraint" "s"<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>WHERE ("s"."consrc" ~~* '%srid(% = %'::"text")) "sr" ON ((("sr"."connamespace" = "n"."oid") AND ("sr"."conrelid" = "c"."oid") AND ("a"."attnum" = ANY ("sr"."conkey")))))<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span class=gmail-apple-converted-space><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'> </span></span><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>WHERE (("c"."relkind" = ANY (ARRAY['r'::"char", 'v'::"char", 'm'::"char", 'f'::"char", 'p'::"char"])) AND (NOT ("c"."relname" = 'raster_columns'::"name")) AND ("t"."typname" = 'geometry'::"name") AND (NOT "pg_is_other_temp_schema"("c"."relnamespace")) AND "has_table_privilege"("c"."oid", 'SELECT'::"text"));<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-- For binary upgrade, handle extension membership the hard way<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>ALTER EXTENSION "postgis" ADD VIEW "public"."geometry_columns";<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal;min-height:15px'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>We are creating below links before the upgrade <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>>>>>>>>:/usr/pgsql-13/lib $ ls -l | grep postgis<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>lrwxrwxrwx<span class=gmail-apple-converted-space> </span>1 root root<span class=gmail-apple-converted-space> </span>30 Aug 18 02:35 </span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-<a href="http://2.4.so">2.4.so</a> -> /usr/pgsql-13/lib/</span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-3.so<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-rwxr-xr-x<span class=gmail-apple-converted-space> </span>1 root root 1076312 May 26<span class=gmail-apple-converted-space> </span>2021 </span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-3.so<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-rwxr-xr-x<span class=gmail-apple-converted-space> </span>1 root root<span class=gmail-apple-converted-space> </span>858608 May 26<span class=gmail-apple-converted-space> </span>2021 </span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>_raster-3.so<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-rwxr-xr-x<span class=gmail-apple-converted-space> </span>1 root root<span class=gmail-apple-converted-space> </span>435648 May 26<span class=gmail-apple-converted-space> </span>2021 </span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>_sfcgal-3.so<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-rwxr-xr-x<span class=gmail-apple-converted-space> </span>1 root root<span class=gmail-apple-converted-space> </span>564928 May 26<span class=gmail-apple-converted-space> </span>2021 </span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>_topology-3.so<o:p></o:p></span></p><p style='margin:0in;margin-bottom:.0001pt;font-stretch:normal'><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>lrwxrwxrwx<span class=gmail-apple-converted-space> </span>1 root root<span class=gmail-apple-converted-space> </span>37 Aug 18 02:35 rt</span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>-<a href="http://2.4.so">2.4.so</a> -> /usr/pgsql-13/lib/</span><b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:#B42419'>postgis</span></b><span style='font-size:10.0pt;font-family:"Menlo",serif;color:black'>_raster-3.so<o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal>Nikhil<o:p></o:p></p></div></div></div></div></body></html>